Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518

    I couldn't test because the file you posted has linked tables, which obviously don't work for me. What's the data type of the AFRNumber field?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  2. #17
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Put a space Before and After the = sign

  3. #18
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    179
    The AFR Number field is set to 'Number' in the table.

    I put a space before and after the = sign and it didn't help.
    Here is the version before splitting the database.

  4. #19
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    This works
    Attached Files Attached Files

  5. #20
    billgyrotech1 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    May 2019
    Posts
    179
    Thanks Mike it does work but can the field (or is it "control"?) be cleared if the number exists so the user can try again?

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 05-13-2018, 12:59 AM
  2. Replies: 4
    Last Post: 04-26-2018, 01:23 PM
  3. Replies: 4
    Last Post: 01-14-2016, 02:18 PM
  4. Duplicate data message for a data entry form
    By JulieMarie in forum Access
    Replies: 5
    Last Post: 07-30-2013, 08:18 AM
  5. Command continues to popup message box..
    By Stephanie53 in forum Forms
    Replies: 12
    Last Post: 05-30-2013, 02:23 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
  •  
Other Forums: Microsoft Office Forums