Lookup

[chef]

I am hoping someone can help....

I have table called tblstaff which has details of paynumber,forename,surname,department,location.

I want to type in a paynumber in a form which would then lookup tblstaff and automatically populate each field with forename,surname,department and location.

Hope this makes sense and hopefully someone can point me in the right direction.

Regards
Chef

 

[rjhare]

I wonder if you are able to use a subform to display your data. Shed loads of help in the Access help file on this one, one should suit your needs.

Good luck with your project

 

[Dugantrain]

Maybe you'd consider a combo box with all of your available choices already loaded in rather than manually typing? If so:
-Drag-drop a combo box onto your form. When the wizard comes up, select the third selection "Find a record on my form based...". For some reason the wizard sometimes doesn't offer this option; if you need the code (it's really simple), then post back.