On Open Form Gives Error Msg

[Guest]

when I open my form it gives me the following msg; "The record source
'~sq_cfrmPtDemographicNew~sq_clstVisit' specified on this form or report does
not exist."

I does not exist because I deleted it and used a different object as the
source.

The msg goes on to say that I should set the RecordSource property to an
existing table or query.

I have done this and still get the error msg.

Please hlp, thanks RobUCSD

 

[tina]

if you're using A2000 or newer, did you turn OFF the Name Autocorrect option
in this database? if not, suggest you do the following: create a new blank
database, and immediately turn OFF Name Autocorrect from the menu bar Tools
| Options | General tab. compact the database, then import all the objects
from your working database. compact the new database again, and then try
opening the form that was causing a problem.

for more information on Name Autocorrupt, see
http://home.att.net/~california.db/tips.html#aTip3.

hth

 

[Guest]

I got it. thnks Tina

RobUCSD

if you're using A2000 or newer, did you turn OFF the Name Autocorrect option
in this database? if not, suggest you do the following: create a new blank
database, and immediately turn OFF Name Autocorrect from the menu bar Tools
| Options | General tab. compact the database, then import all the objects
from your working database. compact the new database again, and then try
opening the form that was causing a problem.

for more information on Name Autocorrupt, see
http://home.att.net/~california.db/tips.html#aTip3.

hth

 

[tina]

you're welcome

I got it. thnks Tina

RobUCSD