M
Martureo Bob
Hi all ... I have an A2K question / issue regarding requerying the data
behind a BOUND combo box.
User "A" enters something into the input area of the combo box control, but
this change is not yet saved (remember this control is bound). Then Users
"A"clicks a button on the form. That button instructs the VBA code to
requery the list portion of the combo box (because there's a possiblity that
the data behind the list portion of the combo box could have been changed by
User "B" --- sharing the backend database).
Then User "A" clicks the arrow to open the list. Any changes that may have
been made (by User "B") do not appear in the list.
If User "A" DOES NOT modify the combo box control's input area but simply
clicks the form's button to refresh the list, then the he/she does see any
changes made by User "B".
How come this happens?
Any suggestions for a way around it?
Thanks!!!!
Bob.
behind a BOUND combo box.
User "A" enters something into the input area of the combo box control, but
this change is not yet saved (remember this control is bound). Then Users
"A"clicks a button on the form. That button instructs the VBA code to
requery the list portion of the combo box (because there's a possiblity that
the data behind the list portion of the combo box could have been changed by
User "B" --- sharing the backend database).
Then User "A" clicks the arrow to open the list. Any changes that may have
been made (by User "B") do not appear in the list.
If User "A" DOES NOT modify the combo box control's input area but simply
clicks the form's button to refresh the list, then the he/she does see any
changes made by User "B".
How come this happens?
Any suggestions for a way around it?
Thanks!!!!
Bob.
