MS Access Form text box

Question

Good day. I sit possible to change a current text box on a form that requires a data entry to a new field that allows you to select a listed entry from a drop down. Would that be a combo box or list box? Basically, I am populating a table via form text box right now. The name of field is status, and the selections would be 1 0f 5 different ones that appear to select from. Thanks in advance, CP.

Answer 1

Firstly, you will need a referenced Statuses table with a single column, Status, which should be the table's primary key.  Create a relationship between this table and you current referencing table to which your form is bound, ensuring that referential integrity and cascade updates are enforced in the relationship.

In the form change the text box to a combo box and set its RowSource property to:

SELECT Status FROM Statuses ORDER BY Status;