By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

subform row data requery

P: n/a
Does anyone know if refreshing particular row data possible in
subform?

For example:
Subform has two field: Vendor and product

In first row, is it possible that when you select a vendor only the
products associated with this vendor appears in product field.

Go to next row, select different vendor, now only products associated
with this next vendor show up in the product field on the second row
without changing the first row.

Thanks for help
Jimmy
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
What controls are you using to do this - comboboxes?
If so, then the products combo should have a query as a rowsource that
refers to the vendor combo's value as criteria.
You'll need to requery the second combo in the AfterUpdate event of the
first.

Mike Storr
www.veraccess.com
"Jimmy" <qc***@netzero.com> wrote in message
news:f6**************************@posting.google.c om...
Does anyone know if refreshing particular row data possible in
subform?

For example:
Subform has two field: Vendor and product

In first row, is it possible that when you select a vendor only the
products associated with this vendor appears in product field.

Go to next row, select different vendor, now only products associated
with this next vendor show up in the product field on the second row
without changing the first row.

Thanks for help
Jimmy

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.