Not in list event Macro trouble

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

Guest

I have a Combo box in a form that looks up a color for block. if the color
entered on the production form is not in the color table the color form
opens. with a mesage click here to add color to list. The Form Opens and
data can be enter. then the user closes the color form and the new color is
still not available in the production form . And how do I stop the microsoft
error from popping up also.
thanks
 
After you have entered the new color you need to refresh
the combo box. When closing the color form add
Forms!OtherFormName!comboboxName.Requery

Chris
 
Great Chris.. But Where do I write this code I have used a Macro to open
the other form

ON form a if a value is put in that is not in the table The pop up info box
open says click here to add color to database that is the msg in the macro
then i used the openform to open the COLOR form which it does but the
microsoft error pop up also displays after the open form i used the refresh
to refresh the color table I think I need to put more items in the action
thanks for your help

bart

Chris Reveille said:
After you have entered the new color you need to refresh
the combo box. When closing the color form add
Forms!OtherFormName!comboboxName.Requery

Chris
Click to expand...
 
You could put this on the on close event of the form you
are closing or on the onclick event of the combobox

Chris
-----Original Message-----
Great Chris.. But Where do I write this code I have used a Macro to open
the other form

ON form a if a value is put in that is not in the table The pop up info box
open says click here to add color to database that is the msg in the macro
then i used the openform to open the COLOR form which it does but the
microsoft error pop up also displays after the open form i used the refresh
to refresh the color table I think I need to put more items in the action
thanks for your help

bart
Click to expand...
 
Back
Top