Using a AutoLookup query as a form! What about my table?

[FuzzyBear9]

Hi,

I am a newbie trying to implement a database using Acces 97 and I would be grateful for any suggestions to the following problem:

I have three tables:

tblSponsor
tblSurvey
tblTracking

tblTracking has two Lookup Columns, one joined to tblSponsor and one joined to tblSurvey.

I then created a form based on tblTracking for which to enter data. To speed data entry, I created a similar form based on an AutoLookup query so that certain fields would be automatically updated, but I am left with a dilemma.

What do I do with my tblTracking table? The form based on the Autolookup query contains the same Lookup columns found in the tracking table. But information entered into the form does not get updated in the tblTracking. I feel like I am at a loss as to how I should proceed. Have I missed something out????

Thanking you in advance.