on load clear combo box

[slimjen]

All; using access 2010. I have a form with a table with one field for the record source. The field contains the cust num. Then I have a subform with a cust num field and additional data fields. I use a combo box with the cust num field on the main form. I want the user to select the cust num from the combo box and filter the subform to that particular cust num. For some reason; when I added the subform with the wizard; it didn't suggest the master and child links. I had to create them. I select a cust num from the combo box and it doesn't change the subform until I close and reopen the form. I need both forms to clear on load.

I'm using the code afterupdate:

Me.Filter = "[cust_num]=" & cbocust_num
   Me.FilterOn = True

What am I doing wrong please.

[nick404]

Wait you want the form to clear on load or to filter based on your combo box selection? I am getting mixed signals.

[slimjen]

Sorry; I want to filter based on the combo box selection. I also want when the form is opened by the user; the combo box is cleared.

[June7]

Combobox for user to input filter criteria must be UNBOUND - otherwise will change data in record. This means it will already be 'clear' when the form opens.

If the main form is bound then set the subform container Master/Child links properties to synchronize records. Apply filter to main form and only related records will display in subform.

What tables are these forms bound to?

[slimjen]

Thanks All. I had a brain fog yesterday. Got it.