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
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