How do you store it into a query from on the current form? and then pull it
on another form?
You don't "store it in a query".
Data is stored in Tables... ONCE.
It sounds like (and since you haven't explained, I may be mistaken
here) that you have one Form based on one Table, with fields for SSN,
FirstName, LastName, etc; and a different Form based on a different
table, also with fields for SSN, FirstName, Lastname, etc.
That is, you are storing the FirstName and LastName redundantly in two
different tables.
If you are doing so... *your table structure is incorrect*. The data
SHOULD NOT EXIST in your second table.
If you just want to *display* the first and last name on the second
Form, without storing them, you can include the FirstName and LastName
in the Combo Box's RowSource query, and put textboxes on the form with
control sources
=cboSSN.Column(n)
where cboSSN is the name of the combo box, and (n) the zero based
subscript of the field containing the name you want displayed. For
example, the RowSource of the combo could be a query
SELECT SSN, FirstName, LastName FROM PeopleTable
ORDER BY SSN;
Its Column Count property would be 3; Bound Column 1 (to store the
SSN); and ColumnWidths could be all nozero so you see the name along
with the SSN when the combo is dropped down.
You'ld have two textboxes on the form with control source
=cboSSN.Column(1)
for the first name, and (2) for the last name.
John W. Vinson[MVP]