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?