Table is not being updated? help

A

azu_daioh

I'm having trouble figuring out why the form "DATA ENTRY" does not
update the table "CLMT INFO"

Here's what I have in forms![Data Entry]
- fo_num (combo box) with Row Source:
SELECT DIFO.DIFO_Num FROM DIFO ORDER BY [DIFO_Num];

- foManager (list box) with Row Source:
SELECT [FO STAFF INFO].Name FROM [FO STAFF INFO] WHERE ((([FO STAFF
INFO].DIFO_Num)=Forms![DATA ENTRY]!difo) And (([FO STAFF
INFO].Title)="Field Office Manager") And (([FO STAFF
INFO].DateStarted)=[CLMT INFO]!entryDate Or ([FO STAFF
INFO].DateStarted)<[CLMT INFO]!entryDate) And (([FO STAFF
INFO].DateEnded) Is Null Or ([FO STAFF INFO].DateEnded)>[CLMT INFO]!
entryDate));

My problem is the TABLE "CLMT INFO" does not update the "foManager"
field with the value displayed on my "DATA ENTRY" form. It only
saves the data on the table whenever I clicked on the "foManager" from
"DATA ENTRY"

Any idea what I need to do to make sure the table is updated with the
information from the form? I tried reading the previous similar
postings and tried most of the recommendations but I still couldnt
figure it out.

Any help is greatly appreciated.

Thank you,

Sharon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top