Run-time error '3075'

Question

I am encountering the error '3075'; Syntax error (missing operator) in query expression '2NDLINE'.

When I run the line:

MsgBox DLookup("2NDCHECK", "TypeLookUp", "[TypeID] =" & Forms![A Form]!cmbChangeType)

Is there anything obviously wrong with this syntax? I cant see anything wrong with it.

Thanks

 

---

Nath

Answer 1

Is TypeID a Text field? Perhaps you need the following:

MsgBox DLookup("2NDCHECK", "TypeLookUp", "[TypeID] = '" & Forms![A Form]!cmbChangeType & "'")

I did add a space as well between the "=" operator and double quote so that may fix it as well without the above change.

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

Hi NaPazz,

>>I am encountering the error '3075'; Syntax error (missing operator) in query expression '2NDLINE'.

According to this error message,I think the error may be caused by query string.I'm wondering what's the

cmbChangeType's row source.You could check the criteria like this

Msgbox  "[TypeID] =" & Forms![A Form]!cmbChangeType

So you could know if the criteria meets your need.

In order to provide a solution to your issue effectively, I’m wondering if you could provide more details,

for instance, is TypeLookUp a table name or a query name and show me the table or the query string?

My Regards

Terry

Answer 3

I am encountering the error '3075'; Syntax error (missing operator) in query expression '2NDLINE'.

When I run the line:

MsgBox DLookup("2NDCHECK", "TypeLookUp", "[TypeID] =" & Forms![A Form]!cmbChangeType)

Is there anything obviously wrong with this syntax? I cant see anything wrong with it.

Because your variable name "2NDCHECK" begins with a non-alphabetic character, you need to surround it with square brackets.  Try this:

    MsgBox DLookup("[2NDCHECK]", "TypeLookUp", "[TypeID] =" & Forms![A Form]!cmbChangeType)

---

Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html