I have a form that will query a table called tbl_Schedules.
tbl_Schedules defined as:
On this form is a subform that has as its RecordSource a query of tbl_Schedules.
SELECT field2, field3 FROM tbl_Schedules WHERE field1 = Day.value;
The subform only displays a subset of the fields from tbl_Schedules. On the subform, i have a command button that will add a new record into tbl_Schedules.
This action is handled by
' can i set fields before issuing new record??
DoCmd.GoToRecord , , acNewRec
, i need to update a field that is not explicitly shown on the subform, namely field1
How can I do this?