Hi,

create a button with this code:

DoCmd.OpenForm "FormName", acNormal, , "ID = " & Me.YourTXTfield,
acFormReadOnly

instead of Formname you have du write the name of your Form. And instead
of YourTXTfield you have to use the name of your textfield.
If the column of your table is called ID, it´ll work that way. If not,
you have to change ID to the name of your tables primkey-column.

regards
Jörn


Am 28.05.2010 02:05, schrieb Leza S.:
I am a new at this....

I have 10 names and addresses in a table with other "stuff". Each name has
a User ID #. I want to enter the User ID# in one form and have another form
come up that displays all the other fields in that record. I don't want to
add or edit; I just want the new form to come up with that record's
information.

I am not a programmer, don't understand Dlookup, but have figured out how to
add the "button" macros. Help!!