Sub form and combo box

[rnutts]

I have a form which has a combo box which allows the user to display all the record details on the main form. Also attached is a sub form which shows all the other records that are related to the record being displayed on the main form. The user can click a command button on the sub-form which will then display the record selected in the main form. The problem then is that this stops the combo box working. I have tried the Requery command on form current view and also on the click part of the combo box. Below is the exact code I have used, however I am new to code and am not sure if this is all I need to make it work.

Private Sub Form_Current()
DoCmd.Requery "Combo22"
End Sub

Any help gratefully received

Richard

 

[John Big Booty]

This table might help you to get the correct syntax.