Hello All,

I have a listbox in a form which I want the ability to have
the user double click an item in the listbox and then open another
form. The problem is that the other form runs a query which pulls in
information from 3 other tables. Is there a way that I can pass my id
from the listbox into the query for the form before opening up the
form?

Here is what I have now

DoCmd.OpenForm "Ticket Form", acNormal, , "ALTERNATEKETSUFFIX=" &
myrow, , , acNormal


Thanks for your help in advance,
Nick

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com