I would like a table to have a field that when placed on a form will have a drop down and within the dropdown a list of values (text) that I can select from. Would appreciate some assistance. Thanks
If I understand your question correctly, you wish for a control where the user of the form has to input one of several predefined values, and this value inserted into a table column of the underlying database, correct? Then the actual feature is not one concerning the table or its fields, but the Form and its controls, AFAICT
For a start I presume you have created a table with the appropriate columns and correct data types. You have created one form, and specified the aforementioned table (create any control, right-click on the Control select Form…, specify table on the Data tab).
If so, the answer should be easy. Open your form in edit mode. Select from the Form Controls toolbar (on the left by default) the List box and drag on the form for the desired location of your field. Righ-click on the field and select Control…
The Properties dialog box for that control appears. On the “Data” tab and the entry “Data Field” select one of the columns of the table connected to your form. On the entry “Typeof list contents” select “Valuelist”. On the next entry “List content”, type in your desired text values. Separate the values with shift+Enter. When finished press Enter.
Swith tab to “General”. Here you can change various appearance and functionoptions, but here we are concerned with a few options towards the lower end. Scrool down to find Dropdown… select yes. Line count… select the number of your text values. Multiselection… no
Close the dialog box. Save the form. Close the form. Save the database. Re-open the form.
Hope this will be helpful