Table to form

R

rob peterson

I have a field in a table called ID. 4 posititions.

I have a field in a subform where I want to enter an ID. If the ID is not in
the table, I want to know. How can I connect them?

By the way, if it is not in the table, I would want a message to pop up or
the ability to add to the table on the fly.

Thanks.
 
J

John W. Vinson

I have a field in a table called ID. 4 posititions.
Click to expand...

What do you mean by "positions"??
I have a field in a subform where I want to enter an ID. If the ID is not in
the table, I want to know. How can I connect them?
Click to expand...

Why not simply put a Combo Box based on the table to select only the valid
ID's, so the user can *SELECT* a valid ID rather than making them type one and
slapping their hand if they guess wrong?
By the way, if it is not in the table, I would want a message to pop up or
the ability to add to the table on the fly.
Click to expand...

You can use the "Not In List" event of the Combo Box to add a value to the
table of valid ID's.

John W. Vinson [MVP]
 
Top