After update not running

[Atlascycle]

I have two combo boxes in a form that contains a sub-form. First Combo box filters the part number list via customer name and then you select a part number to select the record on the main form.


the form is not requering after the part number is updated. if I open the form in design view and then go back to form view and reselect the part number the requery will work.

this is the after update code:

Private Sub cmbSelectCustomer_AfterUpdate()
Me.cmbSelectPartnumber.Value = Null
Me.cmbSelectPartnumber.Requery
End Sub



Private Sub cmbSelectPartnumber_AfterUpdate()
Me.Requery
End Sub

I will need to trim down the data base to get it to zip and upload.

thanks for any help you can provide.

Jason

[Atlascycle]

Attached is the data base in question. the form is frmGoals.

Thank you,

Jason

[Atlascycle]

I have been working out of a copy of the real database and when I imported my forms into the original this morning it seems to work.

Not sure why.


Jason

[Atlascycle]

OK I have narrowed it down to when the form is opened off of the switchboard. I had the form set to open in add mode from the switchboard and i changed it to open in edit mode and it is working.


Jason