Form with Subform not Refreshing



I have a form that has a combo box that is related back to a different table.
I also have a command button that opens another form to add a new record to
this second table. When i click refresh command button it updates the data
in the main combo-box drop down menus, but doesnt update/refresh the drop
down boxes in the subform which has the same data. How can i get the refresh
button to either refresh both, or get the form to automaticlly update all
fields without the use of a button?


This the code for that refresh command as it is in my DB -

Private Sub Command48_Click()
On Error GoTo Err_Command48_Click

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

Exit Sub

MsgBox Err.Description
Resume Exit_Command48_Click

End Sub

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads