Forms - Combo Boxes

[minnesotagirl]

I created a form to enter data into a table. Some of the form fields are
combo boxes with dropdown lists. When I enter data, it isn't saving when I
scroll to the next form and not saving in the table either. any idea why not?

 

[Jeff Boyce]

If you have a (combobox) control on a form, the form is bound to a table (or
a query), and the combobox choice isn't saved to the table, the combobox
control probably isn't bound to the field in the table. Check the combobox
to see if it is "unbound".

And why would the choice on one record/form be saved "when you scroll to the
next..."?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[minnesotagirl]

i am pretty new to this - how can I tell if it is bound/unbound? If the form
is base off of table, should the dropdown choices have somehow been indicated
in the table?

 

[Jeff Boyce]

This almost sounds like your underlying table is using a "lookup" data type
field.

When I build a combobox on a form, I use a query to "feed" it the list of
appropriate choices.

Regards

Jeff Boyce
Microsoft Office/Access MVP