Combo Box to show both table data and list of values

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

Guest

Hi Everyone,

On my form I have combo box cboEventType. It gets a list of values "Lunch", "Dinner" and "Breakfast" which are entered manually into its Row Source Property. When I click the OK button next to the combo box, combo box value is entered into some table along with other values from the form into the same table. So I choose "Lunch" on record 1 and when I click on next record this time the same value "Lunch" is carried into the combo box. And let's say I change the value of combo box to "Dinner" and go back into the same record that I previously had, then "Dinner" displays insted of "Lunch" for record one. How can I have "Lunch", "Dinner" and "Breakfast" as list of values in the combo box but still have the combo box showing the value in the Table?

Any help is zealously appreciated!

Al
 
Al said:
On my form I have combo box cboEventType. It gets
a list of values "Lunch", "Dinner" and "Breakfast"
which are entered manually into its Row Source
Property. When I click the OK button next to the
combo box, combo box value is entered into some
table along with other values from the form into the
same table. So I choose "Lunch" on record 1 and
when I click on next record this time the same value
"Lunch" is carried into the combo box. And let's say
I change the value of combo box to "Dinner" and go
back into the same record that I previously had, then
"Dinner" displays insted of "Lunch" for record one.
How can I have "Lunch", "Dinner" and "Breakfast"
as list of values in the combo box but still have the
combo box showing the value in the Table?
Click to expand...

It sounds like you have an unbound form, or at least the
combo box is unbound. If have chosen to go that route, then
you are responsible for coding the connection between the
table fields and the controls.

If the form is bound to a record source table/query, then
you should also bind the combo box to its corresponding
field.
 
Thanks, I was trying to see if there was any way to do it without doing coding.

----- Marshall Barton wrote: -----



It sounds like you have an unbound form, or at least the
combo box is unbound. If have chosen to go that route, then
you are responsible for coding the connection between the
table fields and the controls.

If the form is bound to a record source table/query, then
you should also bind the combo box to its corresponding
field.
 
Back
Top