Form Data Entry Question

[Guest]

I have a form that is linked to a table. The form is primarily used as a
nicer formatted lookup feature for the information in the table. We do
however, from time to time, need to add records using this form. I have added
the ADD RECORD function which works ok except. Much of the data that will
entered for a new record has been entered before and we need to keep that
information as consistent as possible. We would like the ability to choose
data that from a pulldown for each field in the form to formulate the new
record as well as entering new data.

Any help on this would be appreciated.

 

[Guest]

Stephen,

Store the acceptable responses in a second table, and use it as the
RowSource of a combo box whose Limit to List property is set to Yes.

Since certain responses might apply only to certain fields of your table,
use a ResponseType field to limit the displayed entries to those appropriate
to each field.

Responses
--------------------
ResponseID AutoNumber (Primary Key)
ResponseType Number
Response Text

If the user enters a value that's not in the list, you can use the
LimitToList event procedure to take appropriate action.

Sprinks