Requery combo box on a subform


B

Brad

I have a datasheet subform with 3 combo boxes. I have the first 2 combo boxes
cascade to the third. I set the after update on the first 2 combos to requery
the third with the following code:

Me.Dirty = False
Me.cboIssue.Requery

When the next record is selected the requery erases the value in the first
record. Any ideas on how to fix this where the requery only requeries the
active record?
 
Ad

Advertisements

M

Maurice

I understand your wish for this to work only this functionality won't work in
a datasheet mode...
 
Ad

Advertisements

M

Maurice

You mean like a continous form in tabular layout? Nope.. only single form
will do that for you.
 

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


Top