Originally Posted by
June7
...I don't understand why you are getting an input prompt. That indicates to me a query input parameter. If VBA could not find Me.SQA_Number, should trigger an error message, not an input prompt.
I used to think that, too, but in actuality, Access will do this if SQA_Number doesn't exist on the Form named Inv_Payments!
It may simply not exist or it could be spelled differently on the Form being opened.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007