Form visible but doesn't open (Access 2003)

[Norbert Meiss]

I have designed a form in Access 2003 and saved it a couple of times during
development. When I reopened the ADP the form still was in the database
window but didn't react on any command from the context menu. It simply
doesn't show up in design mode. The code behind form is still there.
Decompile, compact and repair doesn't help. I tried to import all objects
into a new ADP file. The import dialog shows the form, but doesn't import -
again without any message. Is this a known issue and is there a solution to
recover the form (some hours work lost).

TIA, Norbert Meiss

 

[Danny J. Lesandrini]

I've seen this in my ADP when the recordsource is wrong. Make sure the Form.RecordSource
is correct and try again. If you set it in code (as I do in my ADPs) then make sure that the sql
is correct.

 

[Norbert Meiss]

This could be true in my case; normally I use unbound forms. For this form I
made an exception and it could be that I changed the underlying view...
Strange anyway.