Selectable field? List/Combo/etc?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

lol...
This should be an easy one for all of you!

All I am trying to do is have a data entry form...one of the fields (Combo,
List/?) on the form should have three options. When I enter information on
the form and select one of the options all information stays in the record
EXCEPT the information from the List/Combo, etc. field. What is the cleanist
way to have that information kept with the record? Any thoughts on why the
selection doesn't follow the record? There are only three possible answers
to the question.

The interesting thing is if I select the field's pulldown from datasheet
view the information stays with the record but not from a form (though I have
tried many options). I know this is a 'user' me issue!...lol

Make sense?

thanks...b
 
It is likely that your combo box is not bound to a field in the form's
RecordSource. Set the ControlSource property to the name of the field.

Sprinks
 
see Sprinks' answer.

and btw...
The interesting thing is if I select the field's pulldown from datasheet
view the information stays with the record
Click to expand...

sounds like you have one or more Lookup fields in one or more of your
tables. if so, recommend you get rid of the Lookups. they're not necessary
at the table level and cause numerous problems. see
http://www.mvps.org/access/lookupfields.htm
note: comboboxes in *forms* are valuable tools and don't cause any of these
problems.

hth
 
It is bound as you state. What should the Row Source Type and Row Source be
in this scenario? I have Value List as the Type with "Education";"Mental
Health";"Law Enforcement" as the Row Source.

Thanks
 
The RowSourceType and RowSource are fine. The only other possibilities I can
think of are:

- The BoundColumn property is not set (to 1).
- You have a typo in the ControlSource name. Select it from the dropdown
list.
- The Lookup Field feature is screwing it up. See Tina's post and follow
her recommendation.
- Your database is corrupted.

Good luck.

Sprinks
 
Thank you both! It was the lookup fields...

tina said:
see Sprinks' answer.

and btw...


sounds like you have one or more Lookup fields in one or more of your
tables. if so, recommend you get rid of the Lookups. they're not necessary
at the table level and cause numerous problems. see
http://www.mvps.org/access/lookupfields.htm
note: comboboxes in *forms* are valuable tools and don't cause any of
these
problems.

hth
Click to expand...
 
Back
Top