Read-only user & subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have just placed permissions on my database. I have found that the group
of users that are set to Read-Only can not see my subforms if there are no
records to display in the subform. The subform just appears as the
background color. If you switch to the next record on the main form and
records exist for the subform, all the fields will appear.

This looks very odd. I would like to see the fields even if the users can't
add in new records...

Any suggestions?

Thanks in advance
G. Wolfe
 
Unfortunately, this has been the way Access behaves for the last 5 versions.

If:
a) There are no records in a form, AND
b) no new records can be added,
then the Detail Section of the form goes completely blank.
Read-only permission gives you condition b.

The Form Header/Footer sections are still visible, but Access may not be
able to get the values and display these correctly either. Details:
http://members.iinet.net.au/~allenbrowne/bug-06.html
 
Thanks for the reply...

Is there a way to see a message that states that there are no records
available, something like this:

=IIf(subfrmTrialCost_Details.Form.HasData,Null,â€No Trial Expense has been
incurred at this time.â€

I used this syntax on my reports when there wasn't anything available, but
I can't get this to work on my form.

Thanks Again.
 
Not really.

In the case of the report, you displayed that message on the main report.
You could do something like that on your main form, e.g.:
=IIf([Sub1].[RecordsetClone].[RecordCount]=0, "No records", Null)

Not ideal though: it flashes as the main form changes records and the
subform clears and loads its records, and it is not in the desired place.

You could also put a label behind the subform control (Format | Send to
Back, in Form Design view), and then toggle the Visible property of the
subform control. That would put the message in the right place, but I
suspect the flashing would be annoying.
 
Back
Top