Add/Edit combo box question

I've got a couple combo box fields in a subform set up to open pop-up
forms on double-click as a way of adding new items to those lists.
When I open the pop-up, add a new item, then close the pop-up form, the
new item is not available in the combo box list.

The row/source type for the combo fields is set to Table/Query and the
row sources are queries of, respectively, a parts list and list of
service types.

I want to get the combo box list to automatically update and show any
new items added through the pop-up form. How can I make this work?

you need to requery the combo after you add the new item in the pop-up.

" wrote:

I've got a couple combo box fields in a subform set up to open pop-up
forms on double-click as a way of adding new items to those lists.
When I open the pop-up, add a new item, then close the pop-up form, the
new item is not available in the combo box list.

The row/source type for the combo fields is set to Table/Query and the
row sources are queries of, respectively, a parts list and list of
service types.

I want to get the combo box list to automatically update and show any
new items added through the pop-up form. How can I make this work?

You have to Requery your combobox after adding the new item!

YourComboboxName.Requery

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1

Do I include that as an Event in the combo box itself or in the pop-up
form used to add items? Such as in "On Close" event of the popup form?

thanks,
Tim

missinglinq via AccessMonster.com wrote:
You have to Requery your combobox after adding the new item!

YourComboboxName.Requery

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200612/1