Blank Form??

  • Thread starter Thread starter S Jackson
  • Start date Start date
S

S Jackson

I have a form that when I call it up will not display its labels or
controls. Note that there are no records for it to display as it is a blank
database, but it still should show me the form and not a blank background,
correct? All the other forms will display properly. I checked the form's
properties and the default view is Single Form and Always Visible. The only
thing a wee bit different about this form is that I think I used a wizard to
correct it.

Any suggestions?
TIA
S. Jackson
 
Access back-end, or SQL Server? I've had this before an it had something to
do with having a primary key in a SQL Server table...may not have anything
to do with your situation though...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Check:

1. Whether the AllowAdditions Property of the Form is wrongly set to
No/False.

2. If AllowAdditions is correctly set to True, check whether the Query you
used as the Form's RecordSource is updateable or not.

If either the AllowAdditions is False or the RecordSource is not updateable
and there are no Records in the RecordSource, you will get a blank Form as
you observed.
 
I have a form that when I call it up will not display its labels or
controls. Note that there are no records for it to display as it is a blank
database, but it still should show me the form and not a blank background,
correct?
Click to expand...

Only if the Form's Recordsource query is updateable. If there are no
records the form won't show existing records; if the recordsource
isn't updateable you won't see the new record either - the symptom is
that you see nothing but whitespace.

Open the Form's Recordsource query in datasheet view; I'd guess that
there is no *> new line at the bottom and that you cannot update it.
Right?

There are a variety of reasons why a query may not be updateable -
post back with the SQL of the query and we'll see if we can help
change that!
 
Thanks! It was the Allow Additions which was set to "no." Changed it and
now it works. Thanks guys!

S. Jackson
 
Back
Top