Creating a subform which displays values from a table

[marcvanderpeet12]

Guys,



I have an access table with two tables: one table with staff id and exam records and one table with staff id and name.

Now I created an input form for inserting new exam records. In this form you have to fill the staff id for who the exam is. I would however also like to include a subform on the form in which you can see the name of the staff id as soon as you enter a number.

So a little like this: http://www.flickr.com/photos/112983354@N05/12901743213/ (but I want to rebuild this and dont know how)?

Anybody know how to do this?

[June7]

Instead consider a multi-column combobox for the staff ID and name.

Or include the staff table in the form RecordSource, join type "Include all records from Exams and only those from Staff that match". Bind textboxes to Staff fields and set properties Locked Yes and TabStop No.