Thanks, Jorn, I tried this and although it worked, it pops up a parameter
search dialog box, which I do not want. I want to be able to type the ID
number into the form I made, click on a "button" and have it go directly to
another form displaying the contents of that record only.
--
Leza
New and Confused User


"Jörn Bosse" wrote:

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!!


.