Help: Forms have no controls

  • Thread starter Thread starter Jazzy
  • Start date Start date
J

Jazzy

Please help me. I have a number of forms that do not show controls when the
bound table or quiry has no record. The form's record source is set to
dynaset.


Thanking you in advance
Jazzy
 
Please help me. I have a number of forms that do not show controls when the
bound table or quiry has no record. The form's record source is set to
dynaset.

Thanking you in advance
Jazzy
Click to expand...

That is correct.
Add at least one record and you will see the controls.

You can code the form's OPEN event to not open the form if there are
no records:
If Me.RecordsetClone.RecordCount = 0 then
MsgBox "There are no records to display."
Cancel = True
End If
 
Thanks for your reply, unfortunately it does not solve my problem. This
forms are used to capture information. At the end of the year, this data
will not be displayed, only records of the new year will be entered. Again
that is were this problem will re-occur again.

Strangely I do have some forms with no records yet the control don't
disapper when they are opened. I have tried to look at what could be
different but I can't what else to change.

Regards
Jazzy
 
Jazzy said:
Thanks for your reply, unfortunately it does not solve my problem. This forms
are used to capture information. At the end of the year, this data will not be
displayed, only records of the new year will be entered. Again that is were
this problem will re-occur again.

Strangely I do have some forms with no records yet the control don't disapper
when they are opened. I have tried to look at what could be different but I
can't what else to change.
Click to expand...

When you still see controls on a form with an empty RecordSet what you are
seeing is the "New-Record" position (like at the bottom of a datasheet with the
*). That new record position is only available if both your form and the
RecordSource allow record additions. If they don't then the detail section goes
blank.

The form header and footer are still visible in this case so you can put a
button or message there that the user will still see. But if you intend this
form to be used to enter/edit data then you have to redesign the query such that
it produces an updateable RecordSet.
 
Back
Top