Updating two subforms

G

Guest

I have multiple subforms that allows the user to change which subform a
record shows up on. The user changes the category in a combo box. The form
performs a requery in the after update event of the combo box. That record is
removed from the subform. Is there a way two make the other subform perform a
requery so the record in question shows up instantaneously? Currently the
user has to push a button to fire the requery for the second subform, at
which time the record removed from the first sub form appears.
 
M

Marshall Barton

JoeA2006 said:
I have multiple subforms that allows the user to change which subform a
record shows up on. The user changes the category in a combo box. The form
performs a requery in the after update event of the combo box. That record is
removed from the subform. Is there a way two make the other subform perform a
requery so the record in question shows up instantaneously? Currently the
user has to push a button to fire the requery for the second subform, at
which time the record removed from the first sub form appears.
Click to expand...


Doesn't doing both requeries in the combo's AfterUpdate
event do what you want?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit combo box to show only values not already selected 2
Sync two subforms 1
Requery unbound textbox 1
using Pass through queries in subform 3
Can't figger this'un out. 7
Error on removing last record from subform 1
Error removing last record from subform 1
How do I create a query which is only a snapshot - no updating 2

Top