Run time error 13 - Type Mismatch (1 Viewer)

Hello All

Having some trouble with this bit of code, the error reports "Run time error 13 - Type Mismatch"

I've highlighted the line it seems to fail on...

Using Access 2003.

Thanks for any and all assistance

You may need to disambiguate between ADO and DAO

Dim Rst As DAO.Recordset
Dim MyDb As DAO.Database

Your a star

thank you

Got the same problem here is the code it fails on Access 2007, trying to make command buttons visible when a form opens for certian employees and not others.
Get a type 13 mismatch error.

If Me.LogInFrmUserIdTxt.Text = "Drb00" Or "tep09" Then
Forms!TimeEntryFrm.TimeEntryFrmOpenAddNewMemberFrm.Visible = True
Forms!TimeEntryFrm.TimeEntryFrmOpenDeleteMemberFrm.Visible = True
End If

You can't do ... ... which is a boolean operation on strings. You need explicitly check the equality for each item and OR those results together, like ...
Other observations:
Possibly 'LogInFrmUserIdTxt' is overkill, particularly if the item is a textbox on the Login form. Certainly there's no confusion about what the thing is, but it can make your code appear unnecessarily complicated. There's a balance somewhere.
You also might not need to explicitly use the .Text property. With textboxes you more commonly use the .Value property, which is the default and therefore not required in your code.