Listbox Help

[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

 

[Nikos Yannacopoulos]

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

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.