MS Access form is blank if no records

Why is the form blank if no records are found in the table that sources the main form or sub form.  I do not allow additions, but I do allow updates.  

Is the rule if I do not allow additions or deletions the form will always be blank if no records are found ?
upobDaPlayaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Neil RussellConnect With a Mentor Technical Development LeadCommented:
If no records are found how can it be anything except blank? It cant display something that it has not found.
0
 
Kelvin SparksConnect With a Mentor Commented:
A form will usually show a blank record. But if you do not allow additions then it cannot show the empty record. So the form is"empty". No field, no nothing.

Is just the way access works.

Kelvin
0
 
PatHartmanConnect With a Mentor Commented:
You may not allow additions on this form but somehow the records got added.  If you want to use the same form for both add/update and you don't want it set to allow additions, you can add a button the user can press and you can change the form properties to allow additions if the user needs to add.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
There seems to be a lot of confusion about your question, based on the Expert's responses.

So lets be clear:
Why is the form blank if no records are found in the table that sources the main form or sub form.
So are you saying that the source table HAS records, ...yet they do not display in the form?
If so, then perhaps you have the "Data Entry" property set to YES.
Setting the data entry property to Yes will always display a blank form (ready for the user to enter new records only.)
If this is the case, set the Data entry property to NO.

JeffCoachman
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Why is the form blank if no records are found in the table that sources the main form or sub form.
What would you prefer to see if there are no records?
0
 
upobDaPlayaAuthor Commented:
The confusion for me was I had a control button on the form so it could be pressed on and import records.  This button was not visible and I thought at minimum it should be visible.  Thus, I moved the button from the details section to the page footer.  I agree if there is no records why would I expect to see anything.  Sorry for the confusion and thanks for the inout.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.