I have a form with several cascading combo boxes. The data for each combo box comes from a query that writes to a table called rowsourceX. Access automatically gives a warning about pasting new records into rowsourceX. I have used the following code to turn off the warning:
Private Sub Form_Load()
DoCmd.SetWarnings False
End Sub
however, at times the warnings still pop up. It seems to be random. I am using Windows XP and A2K. My user has XP and Access 2002.
I use the form unload event to turn the warnings back on.
Any help will be greatly appreciated!
Tom
Private Sub Form_Load()
DoCmd.SetWarnings False
End Sub
however, at times the warnings still pop up. It seems to be random. I am using Windows XP and A2K. My user has XP and Access 2002.
I use the form unload event to turn the warnings back on.
Any help will be greatly appreciated!
Tom
