details form open from listbox selection

[accesshelpme]

I have a listbox on my main form(named:customer editor). I want to be able to double click an item in the list box(name:list91) and bring up another form called productdetails. I want this to bring up the details of teh particular record in selected from the list.

so i know
in the listbox double click event:

DoCmd.OpenForm "ProductDetails"

but what else would i have to put in the code to ensure that it only opens up the details for that specific slection from the listbox

any help is greatly appreciated!

[June7]

Use the WHERE CONDITION argument:
DoCmd.OpenForm "ProductDetails", , , "fieldname='" & Me.listbox & "'"

If the field is not text type, remove the apostrophe delimiters, date type uses # delimiter.

[accesshelpme]

ill try that

[accesshelpme]

ok, so it seems to be working, hwo would i add another where condition to this code?.........i have this so far
DoCmd.OpenForm "ProductDetails", , , "Products='" & Me.List91 & "'"

I also have a textbox that hold Client_Account_Name. I want to only show the record if its Client_Account_Name is equal to the one in this box.

[June7]

If both criteria will always be provided then simply:

DoCmd.OpenForm "ProductDetails", , , "Products='" & Me.List91 & "' AND Client_Account_Name='" & Me.textbox & "'"

Do clients have ID? Better to search on unique ID than names.

[accesshelpme]

yes, it seems to be working ok, however if a customer has more then one instance of the same product...it will obviously show them all, and wont only show the selected record. There is a ID in the table that is unique to each instance of the product. Even without this ID being present in the listbox(list91) is there a way to make the where statemtn based on the id in the table related to the selected product in the list?....this would eliminate the problem of having more then one instance of the same product for a client

[June7]

Perhaps you also need the Order ID as criteria. Would each order have more than detail record for the same product?

[accesshelpme]

yes that is what the ID in the table is ...its essantially order ID. theres is an ID column, client_account_name, product column, vendor column, and details column. a client can have more then one instance of the same product. yet if there is numerous instances of the same product when i click one in the listbox it will open the details form with all of those records available. I want to go to that specific record related to the specific instance of a product i clicked in the listbox

[accesshelpme]

I would just add vendor to the where statement since it would likeely never happen that a client would have identicall products with identical vendors. But vendors is a multivalue field and can't be added to a where statement

[June7]

Why is vendors a multi-value field?

I NEVER use multi-value field.

Do you want to provide project for analysis? Follow instructions at bottom of my post.