Form Query

[Guest]

Please can you help me as I have a form called assets1 and the record source
is Tblassets.What I would like to do is take another table called audassets
which has columns with the person, date and time of the last person who
updated the record. I would like to add the person, date and time of the last
person who updated the record into the asset1 form to tie in with asset in
the TBLasset.

This is what I was hoping the asset1 form would look like.
Asset
Status
Model
Location

User Name and Time

 

[Guest]

Hi Arlene

Create a query that joins Tblassets to audassets and select all the items
you need in your form. Then set this query to be the record source of your
form assets1.

hth

Andy Hull