M
miss031
I have a form with a search subform, and an unbound subform, which is bound
when a user selects on option in the option group. Now when a user selects a
record from the search form, it filters the main form by that record, then,
when they select one particular option, I would like to load the subform, and
then run an update query.
Right now, when the user chooses a record, then chosses the option for that
subform, the qery says it updated, but it did not. If I choose another
option, and then go back to that option, the query runs and actually updates
the information. I have the query running in the Form_load event, but that
only works one time.
I think it should be in the Form_filter event, because I would like the
query to run when a new record is chosen if that subform is already open. I
tried it in the Form_current event, but then it keeps running over and over,
and in the Form_activate event, it does nothing.
when a user selects on option in the option group. Now when a user selects a
record from the search form, it filters the main form by that record, then,
when they select one particular option, I would like to load the subform, and
then run an update query.
Right now, when the user chooses a record, then chosses the option for that
subform, the qery says it updated, but it did not. If I choose another
option, and then go back to that option, the query runs and actually updates
the information. I have the query running in the Form_load event, but that
only works one time.
I think it should be in the Form_filter event, because I would like the
query to run when a new record is chosen if that subform is already open. I
tried it in the Form_current event, but then it keeps running over and over,
and in the Form_activate event, it does nothing.