Am 04.06.2010 01:26, schrieb Leza S.:
In response to your questions:

1. Regarding name of textbox, I don't have a textbox. I was using a field
pulled
from the table.
2. No query set with parameters for new form
3. The name of my ID-column is AlienID (set to key field)

The name of form I want to open first: InitialVerify

Hope this helps you help me . This is for a new job I have. Thanks for
being so helpful.

Leza

Hey,

the field, where you enter your number has a name. you can see that name
in the properties of this fiel if you open your form in the design-mode.
If think that your id is an integer, thats what it should be as primkey.

DoCmd.OpenForm "InitialVerify", acNormal, , "AlienID = " &
Me.YourTXTfield, acFormReadOnly

check the name of the field, you enter your values and change
YourTXTfield to that name.

If your AlienID is a string you have to type it like this:

DoCmd.OpenForm "InitialVerify", acNormal, , "AlienID = '" &
Me.YourTXTfield & "'" , acFormReadOnly

An integer value has only numbers and a string can include numbers,
letters etc.

integer: 123
string: "Hello%123"

Regards
Jörn