list box query

[vineet36]

I have a lsitbox displaying the tagids(column of my table). I want to open a record from a table when the user selects a tagid. please help me with the code.

 

[wazz]

are tagids unique?
do you have a form ready?
what have you tried so far?

 

[vineet36]

Tag ids are not unique. i have written a event procedure for on click query like this

SELECT tblAntennaDataNoDups.TAGID, tblAntennaDataNoDups.DetectDate, tblAntennaDataNoDups.DetectTime, tblAntennaDataNoDups.Antenna
FROM tblAntennaDataNoDups
WHERE ((tblAntennaDataNoDups.TAGID)=[Me].[TAGID]);

this prompts an alert box where the user can enter the Tagid and then it displays all the records containing the tagids from the table. Instead i want to directly dispaly the records without the need of alert box.

 

[wazz]

your form might be based on a query that has criteria that asks for user input.
check the query's criteria.
if you see criteria with brackets -- [...] -- remove the criteria.
brackets = get user input.