Saving value entered on a form from a Combo list

G

Guest

When I select a value from a list provided by a combo box, it is not saved in
the record when I reopen the form.
I have a Person table with a PersonGroup field, and a Person Group table.
I created a relationship between the PersonGroup field in each of the
tables, using one-to-many from the PersonGroup table to the Person table.
I created the form for Persons including a Combo box for the PersonGroup
field. This displays the PersonGroups fine and I can select them and add them
into the field for each person, but when I come back again, they are not
there!
Ideas, please!
Thanks
CW
 
J

jahoobob via AccessMonster.com

Make sure the control source of the combo is the field in your table/query in
which you want the value
 
G

Guest

Yes it is. So the problem lies somewhere else...

jahoobob via AccessMonster.com said:
Make sure the control source of the combo is the field in your table/query in
which you want the value
 
J

jahoobob via AccessMonster.com

Is the combo blank or is another value there when you open ti the second time?
Check the table and see if the value is there after you enter it the first
time and after you have opened the form the second time. Did you actually
select the dropdown on the control source and see that one of the fields is
highlighted. I have gone around in circles before only to find that I had
changed the name of the control source field in a table or query and hadn't
changed it on the from.
Yes it is. So the problem lies somewhere else...
Make sure the control source of the combo is the field in your table/query in
which you want the value
[quoted text clipped - 11 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top