Listbox Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables...

tblUSERS & tblTICKETS Both tables contain user_id

The contents of the first listbox(USERS) returns 1 or more records to narrow down the search. Once the appropriate listbox entry is identified, I would like a "double-click" event to use the selected user_id to become the criteria for populating the second listbox that would contain all tickets associated with the selected user.

I hope this makes sense.....thanks in advance for any help.....

Greg
 
Greg,

Presumably, your second combo reads from a query selecting
tickets based on UserID selected in the first...?
The only other thing you need is a macro in the On Change
event of the first one, which runs a Requery action on the
second (no double click required).

Nikos
-----Original Message-----
I have 2 tables...

tblUSERS & tblTICKETS Both tables contain user_id

The contents of the first listbox(USERS) returns 1 or
Click to expand...
more records to narrow down the search. Once the
appropriate listbox entry is identified, I would like
a "double-click" event to use the selected user_id to
become the criteria for populating the second listbox that
would contain all tickets associated with the selected
user.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Write New Field Data From Form Entry Into A Separate Table 1
Inserting items in table from selections in listbox 3
transfer data from one listbox to another 2
how to retrieve multiple colums from a table using a listbox? 1
Help - Updating table entries selected in Listbox 3
Populate subform based upon a query from listbox 1
how do i get listbox selected data into table 3
Listbox questions 2

Back
Top