I have a table named "tblantennadatanodups" that has fields "tagid", "date"," time" and "number of fish". I also have a user interface where a lsit box is present with tagids.Please help me with the sql query to display the row containing the tagid when the user clicks on any id.
I have written the code which pops up a dialogue box for the user to enter the tagid and when he enters it will direct to the table and displays the row.
SELECT tblAntennaDataNoDups.TAGID, tblAntennaDataNoDups.DetectDate, tblAntennaDataNoDups.DetectTime, tblAntennaDataNoDups.Antenna
Instead i want to directly display the record upon mouse click. please help.
Thanks for the reply. I tried looking at your list boxes tutorial. It was helpful in making the multiselect listbox and also i could redirect to query. But i want to pass the value selected by the user from the list box to the query so that a record from a table is displayed based on the tagid selected.
i want to pass the value selected by the user from the list box to the query so that a record from a table is displayed based on the tagid selected.
The aforementioned article shows you how to do just that, keep reading to about 4/5 of the way down. If you still need help building SQL in VB based on user-input via controls, have a look at this other Martin Green Lecture.
Well i have a table with column names start date and end date. I created 2 text boxes where the user can enter start date and end date then upon pressing enter it should open all the records from the table in between those dates.