Opening a Record in Form View

[ndltx5]

I have two forms, the first has a listbox that pulls data from a query, the second you enter data to send to a table. I want to be able to choose a record from the listbox and view it in the second form, so that the form is populated with the data form the record you selected. I have it working a little but I doesn't matter which record I select it always shows the data form the 1st record of the table. How do I get it to show the data from the record I select?

Thanks

 

[PHV]

Make the second form a subform of the first, linked to the listbox.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886