Making sub-form View only, allowedits or both.

S

Syd

I have an application where I'd like to limit what the user can do based on their security level. I'm using a login table with security levels of 200 view/read only, 300 read/write, 400 total access. I've written this function that opens the parent form and sub-form based on the above security levels. But, it's not working correctly yet.

The first one calls the parent form and references the control "EmBedFormSwap" and anything on/it to not allow edits.

The second one calls the parent form, child_form, then, sets the property to not allow edits. However, neither one works. Can someone who has done a similar thing/application assist me in getting this to work. I know I'm close, just not sure how close!

1. Forms![frm_Swapping_Parent]![EmbedFormsSwap].AllowEdits = False

2. Forms![frm_Swapping_Parent]![Child_Form].Form.AllowAdditions = False

Thanks for all the help in advance,
 

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

Help with AllowEdits 2
Help needed with AllowEdits logic 3
Filter main form to records with no related records in subform,maintain updateable recordset 4
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
AllowEdits 5
Help with allowedits 3
Read only form suddenly becomes editable 2
Controlling Sub-form data entry,edits,additions and deletions 0

Top