Auto display name when filling form

[mohiahmed]

Hi everyone,

I wanted to find out how to create a form that has a text box of some sort which the first name and surname of a record will appear as you are completing the form. So when you enter the name of the record in the field the name appears on the form at the same tome.

Any help?

[June7]

Probably need to include related table in form's RecordSource query. Need to know more about your data structure. Can attach project for analysis.

[mohiahmed]

If you can download the following template:

TS001225355 (google search...614kb sorry to big to attach)

and on the student details form when you enter a name you can see that it appears on the form itself...

[June7]

The link I located does not have an Access file.

You have an Access project? Copy, remove confidential data, run Compact & Repair, zip if large, attach to post. 2mb zip allowed. Attachment Manager is below the Advanced post editor.