dixieee

Say you want to populate the firstname of someone's username from this
separate table.

You would have to do the following;

Double click the control you want the name to appear in and in the default
value section of the properties box click the fx button on the far Right hand
side.  Now select to insert a field or group.  Browse to your Employees table
and select the Firstname field.  In the bottom left hand corner of the little
window select 'Filter Data'

Now the improtant bit you have to specify WHERE USERNAME in the Employees
Table is equal to USERNAME on the form.  To select the Username in the
employees table click the drop-down arrow in the first box and select to add
a field of group (notice at the top it tells you it is in the employees
table) and select Username.  In the second box click the arrow and at the top
of the little window change the data source back to the form data source and
browse to the Username field on the form.

OK out of there and that will work for firstname, repeat the steps for the
other controls and they will all autofill.

You do not need to 'query action using a data connection' at all.

I hope this is clearer

Cheers Adam