Results 1 to 3 of 3
  1. 12-17-2018, 02:04 PM #1
    JimO
    JimO is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Dec 2015
    Posts
    126

    Open Form Error message

    I am having an issue with names that contain an apostrophe. The code functions fine with (Jeff Flake) but not for (Tom O'Halleran).

    Code:
    DoCmd.OpenForm "PoliticianDataF", , , "[President]=" & "'" & [Politician] & "'"
    Thanxs

    Jim O

    apostrophe
    Reply With Quote Reply With Quote
  2. 12-17-2018, 02:29 PM #2
    moke123's Avatar
    moke123
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,651
    try
    Code:
    DoCmd.OpenForm "PoliticianDataF", , , "[President]= """ & [Politician] & """"
    Reply With Quote Reply With Quote
  3. 12-17-2018, 02:42 PM #3
    JimO
    JimO is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Dec 2015
    Posts
    126
    Thank you, that does the trick.

    Jim O
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Use Message Box that informs user of error if there is no match when using OpenArgs to open a form
    By Ecologist_Guy in forum Programming
    Replies: 2
    Last Post: 09-18-2017, 11:09 AM
  2. Access Structure Design (form process), open message box with multiple options on error
    By Heathey94 in forum Access
    Replies: 232
    Last Post: 04-17-2017, 01:08 PM
  3. Error message Either an object bound to th etable is open...
    By John778 in forum Access
    Replies: 13
    Last Post: 04-21-2016, 03:33 AM
  4. Can't open an 'in use' MDB from network drive, but get an atypical error message
    By lonwinters in forum Access
    Replies: 7
    Last Post: 12-20-2012, 10:20 PM
  5. Open report filter from form getting error message
    By TinaCa in forum Programming
    Replies: 1
    Last Post: 08-01-2011, 04:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums