No "update" when combo box value selected

[oquinnc]

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).

As it is now, the staus is not binding itself to
the record -- when I come back to the record, the
combo box is blank.

Any suggestions?

 

[KyleS]

Hi,

I have a few questions for you...

Is there a "status" field in the Records table?

Is there anything else in the "status" sub form?

As soon as you let me know, we can get this taken care of for you!

Happy to help,

Kyle :

 

[oquinnc]

Kyle,

Actually I got this fixed! I decided I would rather
use an option group for the status. When I switched,
it worked just fine.

Thanks for your willingness to help.