FORM based on AUTOLOOKUP query does not update TABLE.

[FuzzyBear9]

Hi,

I am a newbie to Access 97 and would appreciate any guidance you can offer on this problem.

I have two tables:

1) tblSurvey
2) tblTracking

They are JOINed:

tblSurvey >one-to-many> tblTracking.

tblTracking is used to track individual companies that participate in different surveys. To speed up data entry for users I created a form based on an AutoLookup query that automatically fills in the start and end date for a given survey for each new record I create, eg.

Survey: Preferences (user selects from combo box)
Name: Company Plc (user enters name)
Start date: 23/11/01 (date automatically filled in)
End date: 18/01/01 (date automatically filled in)

However, when I then examine tblTracking, the start and end date fields are blank. When I examine the AutoLookup query in Datasheet View, the fields are filled!

I am lost! Have I missed a step out? How can I ensure that data entered in the form based on the query will update tblTracking? If I revert to a form based on tblTracking, users will have to manually enter the start and end date each time they create a new record!

I hope someone can help me!