Edit records from listbox

[joecamel9166]

I am entering parts into a repair.
I have a combobox to select the part, then the textbox for description is automatically filled, then I enter the quantity.

I have an unbound listbox that displays the records that I entered based on a query.

I have this all set up so I can add and delete just fine. What I want to do is select the record by dbl click from the listbox and have the part number, description, quantity boxes fill with that record so I can change the partnumber or quantity if needed.

This is all on the same form. I am not using subforms. (tried and couldn't get it to work)



If I need to, I can use it like it is and if an error is made entering the part, I can delete it and reenter the correct part. This is just for convenience.

[RuralGuy]

What code did you have in the DoubleClick event of the ListBox?

[joecamel9166]

I tried using dlookup.
Me.cmbPartID = dlookup(me.lstPartList.column,3)
that filled in the the correct info, but started a new record.
I tried playing with the DoCmd.gotorecord and DoCmd.findrecord, but I couldn't get those to work.

[RuralGuy]

I have an unbound listbox that displays the records that I entered based on a query.

This line seems inconsistent.

[joecamel9166]

Once I get to work, I can break down it down more.