Search results for query: *

I have a listbox bound to a table field named roll. I want to be able to select from the listbox and display the last record of another table named vendor whose field name matches the selection. Sounds pretty easy but it is kicking my butt. Any help would be apprecitated.

When I select the name from the list the form will show the last record from the second table who has the same name as selected. Both tables have a field called name. The first just a list of all names the second being data by names. I just want to bring up last record by name selected.

I want to be able to select a Name from a combo box and have it open another form to the last record in a table containing that name as one of its fields. The combo box is showing a list of names from a seperate table.

Form 1 has a combo box that shows a Field named SerialNumber from Table SN. There is also a Table named identical to each item in table SN. What I want to do is select a Serial Number from Form1 and have it open up a generic form which will show data from its corresponding table. I've tried...