no data in forms

B

bindurajeesh

Short of placing an initial dummy data piece to get the form to show, is
there a more professional way to have the form show when there isn't data in
tables yet?
 
A

Allen Browne

bindurajeesh said:
Short of placing an initial dummy data piece to get the form to show, is
there a more professional way to have the form show when there isn't data
in tables yet?
Click to expand...

No. Forms don't have data. All data is stored in tables, and forms read data
from there.

If your form opens with the Detail section completely blanks, this might
help you understand why:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html
 
L

Linq Adams via AccessMonster.com

If the "no new records allowed" status is unintentional, Allen's excellent
article will help you figure out why. If you've intentionally set
AllowAdditions to No, then you can use something like this to show the form's
controls with an empty record set.

It sets AllowAdditions to Yes if there are no records, then changes it to No
once a single record exists.

Private Sub Form_Current()
If RecordsetClone.RecordCount = 0 Then
Me.AllowAdditions = True
Else
Me.AllowAdditions = False
End If

End Sub
 
Top