Subform with combo box that needs to be updated

[kjpreston]

Hello All,
I am working on an Access 2007 database. I have a form with a subform in it. On the subform is a combo box that I need the users to be able to add to the list. Unfortunately I'm not very literate when it comes to VBA, and what I have found on the web has justed confused me. Is there a way I can let the users update the combo box or should I use something else?

Thanks for your help!
Have a blessed day!
kjpreston

 

[MajP]

is the row source of the combo a value list or based on a table/query?

How would you like them to add to the list?
Pop up a form?
Type in the combo?

 

[dhookom]

First, is your combo box row source a table or query?


Do you understand that adding a record to the table will add a value to the list?

Do you have a form for adding the new value to the table?

Duane
Hook'D on Access
MS Access MVP

 

[kjpreston]

The row source for the combo box is a select statement "SELECT TRAINLIST.SPECIALTY FROM TRAINLIST ORDER BY TRAINLIST.SPECIALTY;". Yes I understand that adding a record to the table will add a value to the list, that's what I need. I don't have a form for adding the value, but I can make one. However, if we can update the table/list after updating the field in subform I would perfer that otherwise, a pop up would be the way to go.

 

[MajP]

Allen Browne covers this well

http://allenbrowne.com/ser-27.html

If you have Access 2007 there are several features that make this easier that you may choose to use or not.

 

[kjpreston]

I'll check it out. Thanks so much.