killyridols
Registered User.
- Local time
- Yesterday, 21:41
- Joined
- Jul 16, 2009
- Messages
- 22
Hello,
Basically I want to perform a parameter query with a drop down menu. To do this I have created a form with a combo box (combo0) and a listbox (list3). The combo box is a drop down menu of sample_id (from my query ANART_pt2) I want the listbox to display the full record from ANART_pt2 for the sample_id selected in the combobox.
In the properties of the listbox, for row source, I have:
SELECT ANART_pt2.sample_id, ANART_pt2.lat, ANART_pt2.long, ANART_pt2.maxi, ANART_pt2.waterdepth
FROM ANART_pt2
WHERE (((ANART_pt2.sample_id)=[forms]![ANARTtest].[combo0]))
ORDER BY ANART_pt2.sample_id;
With the form open, if I select the desired sample_id, nothing shows up in the list box. However, if I right click in the listbox and open properties, select the query builder for row source, then close the query builder and the properties menu, the desired record shows up!
So, it is working, but there must be something small that I am missing! Perhaps something in the properties?
Does anyone have any ideas?
Thank you!
Basically I want to perform a parameter query with a drop down menu. To do this I have created a form with a combo box (combo0) and a listbox (list3). The combo box is a drop down menu of sample_id (from my query ANART_pt2) I want the listbox to display the full record from ANART_pt2 for the sample_id selected in the combobox.
In the properties of the listbox, for row source, I have:
SELECT ANART_pt2.sample_id, ANART_pt2.lat, ANART_pt2.long, ANART_pt2.maxi, ANART_pt2.waterdepth
FROM ANART_pt2
WHERE (((ANART_pt2.sample_id)=[forms]![ANARTtest].[combo0]))
ORDER BY ANART_pt2.sample_id;
With the form open, if I select the desired sample_id, nothing shows up in the list box. However, if I right click in the listbox and open properties, select the query builder for row source, then close the query builder and the properties menu, the desired record shows up!
So, it is working, but there must be something small that I am missing! Perhaps something in the properties?
Does anyone have any ideas?
Thank you!