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

Subform not displaying values from requery

P: 9
I have a form which combo boxes (say cmb1 and cmb2). The form also has a subform with a listbox whose rowsource is a query based on the values selected in the comboboxes.

In the After Update event for cmb2, I put Me.Requery.
When I select a value in cmb2, the values of the query results do not display in the listbox, but it does so the the correct record count at the bottom of the form, and it shows the correct record count whenever I change the values in the combo boxes.

I also noticed that when I switch to datasheet view, the correct number of rows display, but they are blank. In each row I can click on a drop down arrow and it will display the all the records of the query (for example, if there were two results, I see two rows each with a drop down arrow each of which show the same two records).

Thank you for any input
Oct 21 '08 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,599
You can directly Requery the List Box within the Sub-Form, as in:
Expand|Select|Wrap|Line Numbers
  1. Forms![<Form Name>]![<Sub Form Name>].Form![<List Box Name>].Requery
Oct 21 '08 #2

P: 9
You can directly Requery the List Box within the Sub-Form, as in:
Expand|Select|Wrap|Line Numbers
  1. Forms![<Form Name>]![<Sub Form Name>].Form![<List Box Name>].Requery
This worked. Thank you Adezii
Oct 21 '08 #3

ADezii
Expert 5K+
P: 8,599
This worked. Thank you Adezii
You are quite welcome.
Oct 22 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.