Automatic updating a combobox

[Leif Thorsen]

I have a subform named A11 with a combobox based on a question QPersons
containing data of persons.

When I need to add a person because I don´t find him in my combo box I from
the form A11 open a menuform based on the question QPersons and in this form
I add data for a new person .

When coming back to my subform A11 and open my combobox the new person isn´t
there.

How do I do to get him there momentarily when closing my menuform ??

A confused Access-user

 

[Tom Wickerath]

Hi Lief,

I would try either Option 1 or Option 2, as shown on Access MVP Allen
Browne's page, available here:

Adding values to lookup tables
http://allenbrowne.com/ser-27.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Leif Thorsen]

Sorry but Option 1 is not OK because I have more than one field im my
combobox and option 2 I can´t use because I have Access 2003

So - do You have any other ways to do it ???

 

[Tom Wickerath]

Try this page, scrolling past Access 2007 to the "All versions" section:

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


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________