I have a form with a subform. This form is to keep track of billable time per day. When entering data directly, there are no problems. However, I want to open the form from another form where the "billable time" is initiated.
When I enter the billable time then exit the field, the billable time form is opened by a macro with OpenForm, SetValue and GoToControl. OpenForm is Edit, Normal. All the values are transferred BUT the Billable time form only shows that current record ignoring previous records entered for that day. The underlying table shows each record.
How can I get the Billable time form to show all records entered each day?
When I enter the billable time then exit the field, the billable time form is opened by a macro with OpenForm, SetValue and GoToControl. OpenForm is Edit, Normal. All the values are transferred BUT the Billable time form only shows that current record ignoring previous records entered for that day. The underlying table shows each record.
How can I get the Billable time form to show all records entered each day?
