Filter Form problem

DianeG63

Registered User.
Local time
Today, 02:54
Joined
May 13, 2008
Messages
12
Hello All,

I have a form that has several (3) subforms attached to it. I have another form to add new records. I then filter the previous form with the PK from the other form. This worked for several years, but now what is happening is the main form, with the subforms loses all its controls. The form literally goes totally blank. The only way to get it back is to manually close the form and reopen it.

I think what may have happened is that a user tried to open the 2003 version in 1997 and lost some references. I can't for the life of me find the reference it blew. Here are the references I have:
Visual Basic For Applications
Microsoft Access 11.0 Object Library
Microsoft Office 12.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for Applications Extensibility 5.2

If anyone can shed some light on this problem, PLEASE, PLEASE, PLEASE enlighten me!

Thanks in advance
 
You are describing a bound form that has no records in its recordsource.
 
Wahoo!!

Thanks RuralGuy! I looked at the recordsource and a 2nd parameter was added for some reason. I removed it and JOY! Now to find why the other param was added.

Thanks again!
 

Users who are viewing this thread

Back
Top Bottom