I am getting an error on an expression when opening a form = Error 2950
Open Form
Form Name: Request Details
View: Form
Filter Name:
Where Condition: ="[ReqID]=" & Nz([ReqID],0)
Data Mode:
Window Mode: Dialog
I am getting an error on an expression when opening a form = Error 2950
Open Form
Form Name: Request Details
View: Form
Filter Name:
Where Condition: ="[ReqID]=" & Nz([ReqID],0)
Data Mode:
Window Mode: Dialog
Is ReqID a text or number field?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Tried Method 1 & 2, but not the More Information..let me try that now..thanks!
No luck still..
Would you consider using VBA instead of a macro? the code would look something like this
Code:DoCmd.OpenForm "[RequestDetails]", , , "[ReqID]=" & Nz(Me!ReqID, 0), , acDialog
Agree with doing it VBA, error codes in Macro's are notoriously vague.
I think it's a bit odd to get an OLE / Active X error when opening a form?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Guess what! I just removed the "=" sign before [ReqID] and it opened the Form!
Thanks all for your suggestions!
Problem solved!
Good work!
Sorry we didn't catch that for you