Debugging where in the code the error message is derived & which f

[magicdds-]

I have a number of forms opening and closing and while closing a particular
form and changing focus to another form which was already opened, I get a
message asking me to type in what number

forms!FORMNAME!PatientID

I thought the form FORMNAME was already closed. Is there a way to track
where in the code or which form is asking for the PatientID?

Thanks
Mark

 

[Tony Toews [MVP]]

I have a number of forms opening and closing and while closing a particular
form and changing focus to another form which was already opened, I get a
message asking me to type in what number

forms!FORMNAME!PatientID

I thought the form FORMNAME was already closed. Is there a way to track
where in the code or which form is asking for the PatientID?

Put a Stop or msgbox in the code at the beginning of the module and
use F8 to step through your code line by line.

But that message is very likely coming from a query in a forms record
source or combo box source.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/