Finally lick the combo box refresh problem

J

jonefer

What is the trick to finally get a combo box that previously did not have a
value, to now reflect that value if it was added to a table behind the scenes
in VBA?

I thought I had it licked in 2003 by using cmbMyCombox.requery, but I'm
trying that same trick in 97 and not having any luck.

What are the key elements I need to have in place to always make sure that a
combobox shows a newly available record? (No matter what version of Access)
 
R

RuralGuy

I don't know about ac97 but having:
Me.YourComboBoxName.Requery
in the GotFocus event of the ComboBox does it for me in ac2K2.

What is the trick to finally get a combo box that previously did not have a
value, to now reflect that value if it was added to a table behind the scenes
in VBA?

I thought I had it licked in 2003 by using cmbMyCombox.requery, but I'm
trying that same trick in 97 and not having any luck.

What are the key elements I need to have in place to always make sure that a
combobox shows a newly available record? (No matter what version of Access)
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
M

Marshall Barton

jonefer said:
What is the trick to finally get a combo box that previously did not have a
value, to now reflect that value if it was added to a table behind the scenes
in VBA?

I thought I had it licked in 2003 by using cmbMyCombox.requery, but I'm
trying that same trick in 97 and not having any luck.

What are the key elements I need to have in place to always make sure that a
combobox shows a newly available record? (No matter what version of Access)
Click to expand...


Requery has always been the way to do that.

Maybe you have some other factor that's different between
the two situations??
 
J

John Vinson

What is the trick to finally get a combo box that previously did not have a
value, to now reflect that value if it was added to a table behind the scenes
in VBA?

I thought I had it licked in 2003 by using cmbMyCombox.requery, but I'm
trying that same trick in 97 and not having any luck.

What are the key elements I need to have in place to always make sure that a
combobox shows a newly available record? (No matter what version of Access)
Click to expand...

Please post your code. This should work fine in A97.

John W. Vinson[MVP]
 
Top