Form Data Entry Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top