Results 1 to 4 of 4
  1. #1
    Kiran Prakash is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jun 2018
    Posts
    11

    Combo box : Search Option Showing Error


    I have made a combo box for a particukar field . At first it worked ok . Later it is showing error saying " RETURN WITHOUT SUBFIELDS "Click image for larger version. 

Name:	Capture 1.JPG 
Views:	13 
Size:	73.9 KB 
ID:	37879Click image for larger version. 

Name:	Capture 2.JPG 
Views:	13 
Size:	66.2 KB 
ID:	37878Click image for larger version. 

Name:	Capture 3.JPG 
Views:	13 
Size:	96.6 KB 
ID:	37877

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    No idea what that message means.

    Should post code or db for analysis. See instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ijaz8883 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    103
    You are using Macro Code
    Try this code
    After Entering Code convert the combo to text it will better for you because if you type 12 and you have already 1280 it will show automatic 1280 so for the specific record use textbox instead of combo box but if you are using drop down to search then its ok
    replace Your Data source where is "ID"

    Click image for larger version. 

Name:	searchcombo.jpg 
Views:	12 
Size:	23.7 KB 
ID:	37880

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    In my experience, this has always been corruption. I've fixed it by creating a new empty database and importing all the objects from the bad DB.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-28-2018, 01:02 PM
  2. Search Combo Box Error
    By jon84dwk in forum Forms
    Replies: 1
    Last Post: 08-29-2016, 02:15 PM
  3. Replies: 3
    Last Post: 01-29-2016, 08:52 PM
  4. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  5. Combo Box Wizard does not have option form option
    By CementCarver in forum Forms
    Replies: 5
    Last Post: 02-28-2013, 08:54 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