Changing DataEntry property programtically

MonkeyMan666 · April 2nd, 2009, 03:00 AM

Hiya,

I am using a MS Access 2003 ADP Project which connects to a SQL Server 2005 (this maybe the cause of the problem I don't know).

I want to toggle the "DataEntry" property of the forms depending on who is logged in. My code looks up an Admin field from a table containing users and if they have admin rights then I want to make DataEntry false.

My code is:

Code:

    If isAdmin = True Then
        Forms!frmSecondments.DataEntry = False
        Forms!frmSecondments.NavigationButtons = True
    Else
        Forms!frmSecondments.DataEntry = True
        Forms!frmSecondments.NavigationButtons = False
    End If

The navigation buttons are being toggled ok and as I am not getting any error messages I think it could be the record source.

Does anyone have any ideas?

Thanks in advance

MonkeyMan666 · April 2nd, 2009, 03:12 AM

I have found out that the problem is when the form is opened with a filter.

My filter string is something like "Division = 1 OR Division IS NULL"

When I use this a query it works fine but opening it with the form stops the data entry from being modified.

SerranoG · April 2nd, 2009, 04:42 PM

You can use the following form properties: Allow Additions, Allow Deletions, Allow Edits.

e.g. Me.AllowEdits = isAdmin

You can use the following control property: Locked

e.g. Me.txtName.Locked = Not isAdmin