I would like to use a combo box to set the status
of each record in the database. I have a main
table called "Records". I have another table
called "Status".
I then have a form called Records with a sub-form
called Status. The combo box was created from the
Status table.
I want to be able to set the combo box to one of
the choices. Later I want to be able to filter
by a staus (there are 5).
Any suggestions?
of each record in the database. I have a main
table called "Records". I have another table
called "Status".
I then have a form called Records with a sub-form
called Status. The combo box was created from the
Status table.
I want to be able to set the combo box to one of
the choices. Later I want to be able to filter
by a staus (there are 5).
Any suggestions?
