Read only problem

[MarkWaddington]

I have a switchboard item called "enter new client" which when clicked, goes to a new client record. When a user logs in who is read only he/she is bombarded with error messages if he/she clicks that switchboard item. Is there any way to suppress these errors?

Thanks in advance.

 

[IcesMaster]

Are calling a form from the switchboard? If so, please explain the form clearly

 

[MarkWaddington]

The user is presented with errors because when the form opens it automatically goes to a new record. Read only users cannot do this.

I want some kind of statement that does this:

If (ReadOnly) Then

DoCmd.Close

Can anyone help?

Thanks

 

[TorF]

You must check if user can add new record, and de/activate the possibilities to add new record.

See the thread:

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/705/qid/419238

Copy the functions of the last (actually last...) post into a module.

Then in your form OnOpen event, use something like:

Me.AllowAdditions = GetPermission(CurrentUser(), poTables, "MyTable&quot And dbSecInsertData

 

[glrpfi]

i recommend the streamlined approach.

If the user has the lower secuirty level, disable the enter new record control on the switchboard. I can provide you examples offline if you wish.