Table to form

[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.

 

[John W. Vinson]

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

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?

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.

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]