Changing Data Entry Property in a Form

[nobull613]

I have a form used to enter call information. For the reps taking the calls I want the form to be set to Data Entry. When the manager opens the form through an administration form, I'd like it to display all data.

Can I change the Data Entry property to Yes when reps go to the form via a Main Menu and set the Data Entry property to No when the manager goes in via the Admin Form?

Thanks

 

[missinglinq]

You can control this by how you open the forms.

DoCmd.OpenForm YourFormName, , , , acFormAdd

will only allow new records to be entered. Old records can't be viewed/edited.

DoCmd.OpenForm Your FormName, , , , acFormEdit

will allow your managers to view/edit all records or add new records if needed.

Linq

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[nobull613]

That worked great, thank you. It's easier than Forms!frm_NAME.DataEntry = True or False.

 

[missinglinq]

Glad you got it working!

Linq

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!