form not appearing...

[breaker11]

Hi All,
I created a form from a query and have a command button to open it within my database. The problem is that when opened, none of the fields are displayed, instead, a blank screen is shown. I am wondering if there is something simple I am missing here. Any help is appreciated.

 

[Aivars]

Your form's recordset is empty and form.allowadditions is set No. Set Allow additions=Yes on form properties window and open form. All controls will be show OK!

Aivars

 

[breaker11]

Aivers,
The Allow Additions Property is set to yes, and my recordsource is my query. Everything should work out, but the screen I get is a blank gray screen, not even the outline of the form shows up. Let me know if you have any more ideas, thanks again.

 

[Aivars]

No ideas...

 

[JaneC]

Check that the query runs ok. It looks like a) no records are returned from the query and b) the query is returning a non updatable recordset.

The non updatable recordset bit is usually because of the lack of a primary key.

If you run the query and it returns nothing, not even a blank row than the recordset is not updatable.

Hope this helps

Jane