Auto Populate

[jcharbula]

This one should be easy....
How do you autopopulate a field based on the entry of another field?


For example, if I put in a student's SS#, their name will populate in a Name Field on the form

[pbaldy]

One way:

http://www.baldyweb.com/Autofill.htm

Otherwise you can use DLookup() or open a recordset.

[jcharbula]

Thank you, I'm new to Access but know SQL pretty well. Can you give me the syntax for the DLookup in the Expression builder? I'm getting a circular reference error. Everything is in the same table, I just can't figure out how to base the Dlookup on the entry field which is just above in the form? Thanks in Advance

[pbaldy]

See if this helps:

DLookup Usage Samples

To avoid a circular reference error, make sure your control have different names than the fields ("txtFieldname" instead of "FieldName").