Table/Form - Not sure what else to put

[DH010010]

I have a form that loads information on to a table "job details" now in this
form i have it displaying a list of cars from another table "courtesy Cars".
In the current form i want to be able to select a car and enter the hire
dates. thats the easy bit. however i want the hiredates i enter to show in
the table untill the car is returned to me. then i want the dates to be
deleted fro the form "courtesy cares" but remain in the form Job details. can
this be done?

 

[Tom van Stiphout]

On Sun, 26 Oct 2008 12:26:01 -0700, DH010010

Yes. Presumably when a car is returned you look up that job (which
identifies the car) and then you can run an Update query to set those
fields to blank. Something like:
update tblCourtesyCars
set HireDateFrom=Null, HireDateTo=Null
where CourtesyCarID = Forms!MyJobDetailsForm!MyCourtesyCarField

DoCmd.RunSQL can run this query.

-Tom.
Microsoft Access MVP

 

[John W. Vinson]

I have a form that loads information on to a table "job details" now in this
form i have it displaying a list of cars from another table "courtesy Cars".
In the current form i want to be able to select a car and enter the hire
dates. thats the easy bit. however i want the hiredates i enter to show in
the table untill the car is returned to me. then i want the dates to be
deleted fro the form "courtesy cares" but remain in the form Job details. can
this be done?

Ummm...

You are aware that nobody here could possibly have any clue how your tables
are set up, or where you're storing this information, right?

Please give us a little help. I would GUESS that you want to store the hire
dates in a related history table, not in your courtesy cars table, but that's
purely a guess.