Access 2k2. I have a data entry form w/ a command button (submit record) created w/ the command wizard that uses the "new record function". The New record function submits the data entered into the form and displays the fields as empty.
The problem I am having is that the subform data does not update to show the information that was entered w/ the last selection of the command button (submit record). If I close the form and reopen, the information is represented in the subform.
Q: how can I make the subform refresh and display w/ the data just entered when the form updates and displays the data entry fields empty.
Thanks in advance for your help.
The problem I am having is that the subform data does not update to show the information that was entered w/ the last selection of the command button (submit record). If I close the form and reopen, the information is represented in the subform.
Q: how can I make the subform refresh and display w/ the data just entered when the form updates and displays the data entry fields empty.
Thanks in advance for your help.