Form with Subform not Refreshing

[Gary]

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?

 

[Gary]

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_Command48_Click:
Exit Sub

Err_Command48_Click:
MsgBox Err.Description
Resume Exit_Command48_Click

End Sub