Query Help

[rhett7660]

Hi all..

Here is what I am trying to do: I have three tables:

tblMain
entrynumber (pk)
entrydate
empnumber
driverslicnumber
Lname
Fname
Minitial
Address
streetname
City
State
Zipcode
EmployeeStatus
Note
etc

tblrelated
sprId (pk)
entrynumber
Lname
Fname
Minitial
DriversLicNumber
Current
Note
LastUpdated

tblVeh
Vehid(pk)
entrynumber
LicPlateNumber
Current
Note
LastUpdated


What I want to do is have a query setup that if an item is updated (it just captures a date and time that are writen over on each update of the record)[lastupdated] in either of the three tables I want the query to show the [lastupdated]

IE Record #2 was updated on 11/11/2006 5:30pm

doesn't matter if it was the tblveh or tblrelated that was updated.. since the are related to the main table. Does this make sense?

Thanks
R~

 

[boblarson]

I usually just add the fields I want updated, as bound textboxes, (DateUpdated and UserUpdating) on my form and then just set the code to update them on the form's BeforeUpdate event.

in the event I have:

Me.txtMyTextBoxForDateUpdatedNameHere = Now()    (for date/time)
Me.txtUserUpdating = Environ("username")