Thank you for your quick replys.......
my syntax was "=[ssnFromPassword]![Social Security]"
where the query = ssnFromPassword
and the field = Social Security
I got this by using the "code builder" from the properties section of the text box.
I am building a data base tracking student input on each individual class. I am using 2 key fields in the table ... 1 is the [date], and 2 is the [ssn]..... this would allow all student to enter information on each [date] and only allow each student to do one form, but enter information in all [dates].
To get to this form, the student will have to use a [username] and a [password] in the "password" form.
The query uses the [password] to identify the SSn# and I would like the SSn# to be automatically entered on the form. This would make data entry faster and would cut down on mistakes......
once again, thanks for your intrest and help.......
I thank all of you. What you do for others is very special. What you are is special.
Shawn