Populating a Data to another Table

[Chip]

Howdy!

I will try to explain my delima:
I have a database that collects data from facility inscpections there are
basically 2 tables, one is the Physical Facility Information table named
"tblFACID" that contains the address, facility name and other general
information about the facility. The other table is the checklist
information from the Inspection named 'tbl_SAV" with a date of the
Inspection.
I am trying to get a form (or something?) to populate a field in the
Physical Information Table (tblFACID) with the date of the latest Inspection
for that facility. I am really lost on this one and not sure how to do this
at all. I am new to ACCESS and VB but know just a little about both. Can
anyone assist me with how to accomplish this?

And as always, THANKS IN ADVANCE!!!

 

[Shao]

Since you are a newbie try looking at example databases.
Microsoft has several Access templates. If you find
something smiliar to what you want you can just cutomize
it. http://office.microsoft.com/templates/default.aspx

If you use VB to populate the tables take a look at the
Events section under the properties in form. That should
give you a good start.