Results 1 to 12 of 12
  1. #1
    kikomeister is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7

    Error 2950 on Macro when Opening Form

    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

  2. #2
    kikomeister is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7
    Click image for larger version. 

Name:	Error 2950.png 
Views:	10 
Size:	8.6 KB 
ID:	45860Click image for larger version. 

Name:	Access Error.png 
Views:	10 
Size:	8.6 KB 
ID:	45861

  3. #3
    kd2017 is online now Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    882

  4. #4
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,009
    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 ↓↓

  5. #5
    kikomeister is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7
    Tried Method 1 & 2, but not the More Information..let me try that now..thanks!

  6. #6
    kikomeister is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7
    Quote Originally Posted by Minty View Post
    Is ReqID a text or number field?
    It is a number field.

  7. #7
    kikomeister is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7
    Quote Originally Posted by kd2017 View Post
    No luck still..

  8. #8
    kd2017 is online now Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    882
    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

  9. #9
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,009
    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 ↓↓

  10. #10
    kikomeister is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7
    Quote Originally Posted by kd2017 View Post
    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
    Will try this..ty

  11. #11
    kikomeister is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2021
    Posts
    7
    Guess what! I just removed the "=" sign before [ReqID] and it opened the Form!
    Thanks all for your suggestions!
    Problem solved!

  12. #12
    kd2017 is online now Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    882
    Good work!

    Sorry we didn't catch that for you

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-05-2018, 04:19 PM
  2. Error 2950 when opening database
    By jfkboise in forum Macros
    Replies: 4
    Last Post: 10-21-2014, 11:14 AM
  3. Debug Macro Error 2950
    By DMJ in forum Macros
    Replies: 1
    Last Post: 03-13-2014, 03:12 PM
  4. Error with macro while opening access.
    By Trisha in forum Access
    Replies: 5
    Last Post: 03-04-2014, 01:07 PM
  5. Replies: 2
    Last Post: 09-30-2009, 09:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums