Read Only User Error

M

Mike T

I'm using the following line in the Control Source of a text box on my main
form that subtracts the value in a calculated field on the subform to
display remaining funds...

=([Max Misc]-[Forms]![Grants - Financial].[Grants - Financial Sub
Misc].Form.txtTotalMisc)

It works fine for read/write users but displays #Error for read only users
when no data has been entered on the subform (all subforms for read only
users appear grayed out when no data has been entered). I tried using the Nz
function to no avail. Can someone help me with a solution or work-around for
this annoyance? I'd appreciate any help you can provide.

Thanks,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Read Only User Error 0
Design Help, Please 0
subform 5
data entry in subform before mainform causes huge hassle, HELP! 2
Multiple quotes for same job number using option buttons 1
Set focus in a specific record within a subform 1
Main \ Sub Form Data 1
Embedded macro not allowing data entry 1

Top