Run-Time error '2447': help

[SoxPats83]

i am getting the following error in an on click event for a login form i have created.

Run-Time error '2447':

There is an invalid use of the . (dot) or ! operator or invalid parenthesis.

the debugger highlts the following field:

![computer_login] = Me.txtUser_hidden

now, this is in reference to db attatched @ http://www.access-programmers.co.uk/forums/showthread.php?t=163000&highlight=multi+user+login under the frmUserLogon form. i have taken liberties with the naming of my fields, but i did not make any drastic changes to the VBA coding itself. i am starting to go nuyts with this. help as always is appreciated.

Thanks!

 

[Trevor G]

If it is this line

![computer_login] = Me.txtUser_hidden

you have not indicated the element before ! and have not got a .value shown.

Why not zip your database so someone can take a look at it for you.

 

[SoxPats83]

could you give me an example of a .value? i am unable to share my db, sorry.

 

[Trevor G]

What I have done is attached a copy of a security database system which I use, there are various things you will have to look for. But I hope it helps you.

To look through the database use the F11 function key so it brings the database window to the front then look at each element and see if it will assist you with your design.

The other instructions are as follows:

I hope this maybe useful.

I have added some instructions on each form and also I am listing the elements here:

Modules used:
modCheckForUSer
modOutlook (reference has to be set to allow emails to be sent)
modUserLog

Tables:
tblStaffAccess
tblUserLog

Forms:
frmAccessList
frmLogIN
frmMenu
frmMonitor (Remains hidden from view)
frmStart
frmUserLog

Macro:
Autoexec

I also set the form size so they overlap each other in the same place etc.