View Single Post
  #3 (permalink)  
Old January 17th, 2008, 09:03 AM
firefighter2045 firefighter2045 is offline
Authorized User
Join Date: Oct 2007
Location: , , .
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts

Let me try again.

I have two tables
Table A has field LastServiceDate
Table B has field ServiceDate

I have a continues form called ServiceNeeded which is based off of a query which uses Table B. The query shows all the records in Table B where ServiceDate is Null.

What I want to do is if someone enters values into the ServiceDate field, when the form closes I would like to take these values and put them into Table A in the LastServiceDate column based off of the primary key field called PartID.

This means I could be trying to modify any number of records including 0 at one time.

My problem is that I don’t know how to start setting up the code to do this. I know I need to create a recordset, but I cannot figure out the structure to accomplish what I am trying to do.

I would greatly appreciate any help I could get with this.

Reply With Quote