Requery?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form A that has a Combo box for part selections. I also have a
button next to the txt field where it opens a little form to add additional
parts as needed. However I cant get the part to show up in Form A (main Form)
after I have added it to form B. I have tried every type of requerry on each
form and control but nothing works. Please help.
 
I have had similar issues with combo boxes. My fix was in the OnClose event
of the Add Part Form, I close and re-open the main form. That forces the
combo box to requery.
 
Yes I have done that in the past but you would think with Access 2007 they
would have fixed it. Funny if I place a button next to the cbo it works fine.
But no way will it work on the cbo dbl clck property.
Go figure?
 
TKM said:
I have a main form A that has a Combo box for part selections. I also have a
button next to the txt field where it opens a little form to add additional
parts as needed. However I cant get the part to show up in Form A (main Form)
after I have added it to form B. I have tried every type of requerry on each
form and control but nothing works.
Click to expand...


There must be something funny in your arrangement ;-)

After the "little" form closes, the code in the button's
click event procedure should resume (you are opening the
little form in Dialog mode, right?) and then you can
requery.

DoCmd.OpenForm "littleform", WindowMode:=acDialog

Me.combobox.Requery
or
Me.Requery
 
Back
Top