add a record

[Rpettis31]

I have a form with a listbox that has items and I would like to select an
item record from the listbox and lookup the value on another table by opening
up an item details form frmItem_details. I know how to get the value from the
list box, on a focus event
strItem=me.lstbxItemList.column(1).Value however, I do not know how to open
the details form looking up the item that was selected. I would like to
either get the detail record or be able to create a new record.

 

[PieterLinden via AccessMonster.com]

I have a form with a listbox that has items and I would like to select an
item record from the listbox and lookup the value on another table by opening
up an item details form frmItem_details. I know how to get the value from the
list box, on a focus event
strItem=me.lstbxItemList.column(1).Value however, I do not know how to open
the details form looking up the item that was selected. I would like to
either get the detail record or be able to create a new record.

pass the value (strItem) in the DoCmd.OpenForm command to show only that
record. IF you're only selecting a single value, why not just use a combobox?