MsgBox "Estimate imported. Proceed to job schedule. Be sure to check for outside purchase information."
The problem is this... if there is no "EstimateWonOutbuys" import the message box does not appear. If both imports take place then the message box does appear. I need it to appear in either case. There are cases where there is no import to be done for "EstimateWonOutbuys".
--Steve
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
8/22/2022 - Mon
Rey Obrero (Capricorn1)
do you have error handling codes that goes with the codes above?
or, is there an
on error resume next line
Rey Obrero (Capricorn1)
comment this two lines, then test your codes again
' DoCmd.SetWarnings False
' DoCmd.SetWarnings True
SteveL13
ASKER
I commented those two lines out and the message box did not popup when only the first import existed.
or, is there an
on error resume next line