Link to home
Start Free TrialLog in
Avatar of wlamore
wlamoreFlag for United States of America

asked on

Access field data entry options

Maybe this is more complicated then I would hope, but.  I create tables and queries in Access all the time, but have never had to do more than simple data sheets. I would like to have a field on a form that could be populated via simple data entry from the keyboard with an option to fill the field with a selection from pop up-lookup list based on a predefined query. I have some predefined items, but I want the user to have the option of entering their own text item. The item they enter does not have to be in or added to the pop up-look up list.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wlamore

ASKER

Yea, I think a combo box would work fine. The items in the combo box are from a query that is based on an entry in a previous field in the form. IE. If the user selects floors in the "Type" field, Then I only want item that are categorized as "Floor" items to appear in the combo box. So I should be able to fill the combo box with the results of a query using the data entered in that previous field, in the same form,correct? And a combo box field allows for direct text entry, correct?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial