Requery of Subform with combo box

[packwood]

I have a subform that has a query on another table. One of the fields
is based on the contents of another table. When the user selects one
or other option in the main form I want the the records in the combo
box to show the new selection.

I have tried putting the requery action in many of the events on the
main form but cannot get it to refresh to show the new records. If I
close the form and reopen it or use Records - Refresh on the menu of
course it all updates correctly.

Hopefully this illustrates the problem.

frmMain form - sfrmSubform - qrytblTable - tblTable - RowSource
| ^
| |
Option Group tblRows
| ^
| |
Option buttons----->tblRecordType----------------------->|

Where and how do I place the requery, if that is the way to do it?

[Holtz]

In the AfterUpdate Event of each option put the following:

Dim Qry as string

Qry = "SELECT * FROM TblName WHERE Condition" (Whatever you want to
select)
ComboBox.Rowsource = Qry
DoCmd.Requery "ComboBox"

If you are using Option Buttons put an IF condition to check it the
Option Button's value = -1 otherwise it will check when you deselect
the option too which is not what you want.