SD8146
Technical User
- Jul 8, 2005
- 14
I have an access database that records incidents in the workplace, there are several tables, the main three being:–
tblINCIDENT - tblINCIDENT.IncidentID (key); tblINCIDENT.SubordID; IncidentDate, etc
tblMANAGER - tblMANAGER.ManagerID (key), FirstName, Surname, etc
tblSUBORD - tblSUBORD.SubordID (key); tblSUBORD.ManagerID; FirstName, Surname, etc
…. plus other fields
Form based on tblINCIDENT which includes sub forms based on tblMANAGER and tblSUBORD
Within form are 2x Combo boxes bound to ManagerID and SubordID used to select the appropriate record from each table.
The combo boxes select the correct records but, whereas the tblMANAGER subform displays the relevant data immediately, the tblSUBORD subform does not. The data is recorded in the tblINCIDENT and is there when I go back to the form view.
Is there anything I can do to force the display to refresh at the time of data entry?
I would be most grateful for any guidance, thank you.
tblINCIDENT - tblINCIDENT.IncidentID (key); tblINCIDENT.SubordID; IncidentDate, etc
tblMANAGER - tblMANAGER.ManagerID (key), FirstName, Surname, etc
tblSUBORD - tblSUBORD.SubordID (key); tblSUBORD.ManagerID; FirstName, Surname, etc
…. plus other fields
Form based on tblINCIDENT which includes sub forms based on tblMANAGER and tblSUBORD
Within form are 2x Combo boxes bound to ManagerID and SubordID used to select the appropriate record from each table.
The combo boxes select the correct records but, whereas the tblMANAGER subform displays the relevant data immediately, the tblSUBORD subform does not. The data is recorded in the tblINCIDENT and is there when I go back to the form view.
Is there anything I can do to force the display to refresh at the time of data entry?
I would be most grateful for any guidance, thank you.