One form two search combo boxes created with the wizard which finds a record on the form based on the value selected in the combo box.
Combo box works a treat. However, when I add a new record the combo box list does not update with the new record. It does if I close the form or put it in design mode and reopen it.
I've tried Me.ComboBox.Requery, no luck. I either get error messages or blank lists!
Also, I have a subform with one field which runs off a query finding a max value for all records. I'm unable to refresh this value to the updated value, I'm guessing solving one issue will solve for the other too.
Any ideas as to what I'm doing wrong?
Combo box works a treat. However, when I add a new record the combo box list does not update with the new record. It does if I close the form or put it in design mode and reopen it.
I've tried Me.ComboBox.Requery, no luck. I either get error messages or blank lists!
Also, I have a subform with one field which runs off a query finding a max value for all records. I'm unable to refresh this value to the updated value, I'm guessing solving one issue will solve for the other too.
Any ideas as to what I'm doing wrong?