Results 1 to 7 of 7
  1. #1
    AndyRob1973 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2020
    Posts
    81

    combo box search problem

    Hello,



    I have a form which has a sub form.

    When I open this main form and choose from the dropdown combo box, I get the spinning circle and have to kill the process.

    However if I open this main form and choose from a dropdown box in the subform and then go to the combo box mentioned above it works fine.
    Can anyone help? Or do I need to attach the database on here?

    Thankyou.

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

    Makes it easier if you attach the database
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  3. #3
    AndyRob1973 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2020
    Posts
    81
    Thankyou,

    I have added two zip files. One with the database (Access 2010) and one with the description of my problem.
    Attached Files Attached Files

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

    The database opens just fine and the selection of a Study works just great for me.

    You can try the following steps:

    1. Check that you are not missing any references in the VB Editor.

    2. Do a Compact & Repair

    3. Create a Blank new database and then Import your original database
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

    See if the configuration of your Forms has sorted the issue?

    I made the Study Subform a Continuous Form vice Datasheet

    I also moved the Payments Subform out of the Study Subform and then linked both the Study & Payments Form using a Form Reference which is highlighted in Yellow

    To add payments for a Patient you just select the specific Patient

    You can PM me if you need detailed explanations
    Attached Files Attached Files
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  6. #6
    AndyRob1973 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2020
    Posts
    81
    Thanks Mike,

    I’ve been through your first post. The compact and repair didn’t work but importing the database into a new one did!

    For future reference, what did you mean by ‘Check that you are not missing any references in the VB Editor’?

    I will have a look at your second post and see if I can work it out.

    Much appreciated!
    Andy

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

    Missing references can be checked By:-


    • Open your database.
    • Press ALT+F11 to open the Visual Basic Editor.
    • On the Tools menu, click References.
    • Click to clear the check box for the type library or object library marked as MISSING: <referencename>.

    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Replies: 5
    Last Post: 09-22-2016, 08:42 AM
  2. Replies: 3
    Last Post: 01-04-2015, 06:09 PM
  3. Replies: 7
    Last Post: 08-08-2012, 03:28 PM
  4. Search Problem
    By martyloo in forum Access
    Replies: 1
    Last Post: 09-30-2011, 02:55 PM
  5. Replies: 4
    Last Post: 08-16-2011, 05:54 PM

Tags for this Thread

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