Combo box, Form design Question (1 Viewer)

[cross5900]

I am trying to come up with a good, clean and efficient way to solve a problem of mine.

I have my main form that has a combo box that allows an associate to put a set of information in (a name) and then once they type it in, to hit a command button that pops up a second form for the contact information to be inputted if needed.

The 2nd form is actually not the problem, that works great. What I need to figure out is a good way for the combo box to be dynamically updated when this new set of information is put in.

Any good ideas?

 

[gemma-the-husky]

cbobox.requery

 

[gemma-the-husky]

more particularly

when you open the popup form put code

in the event that opens the popup put the following

docmd.openform "popupform"
while isopen("popupform")
doevents
wend

cbobox.requery

if you dont trap the form open, the code will drop through wihout waiting for the popup to close, which may be why you are not seeing the cbo box refresh properly

 

[cross5900]

Thanks, I will give this a shot and let you know how it works out.