Results 1 to 2 of 2

Missing combo box option

This is a discussion on Missing combo box option within the Microsoft Access forums, part of the Question Forums category; (3rd option,) Find a record on my form based on the value I selected etc is not available for a ...

  1. #1
    New Member
    Join Date
    Jul 2005
    Location
    New South Wales
    Posts
    6

    Default Missing combo box option

    (3rd option,) Find a record on my form based on the value I selected etc is not available for a combo box after the form has had any modification.
    Any ideas why.

  2. #2
    Board Regular Corticus's Avatar
    Join Date
    Apr 2002
    Location
    Sarasota, FL
    Posts
    1,585

    Default

    Firstly, that wizard uses a really bizarre method to go to the selected record, I don't like it.

    I'm thinking if you did a repair on Access, it might show up again.

    But, I would recommend have a filtered record source for your form as a better means of going to a selected record, I explain how in this post:
    http://www.mrexcel.com/board2/viewtopic.php?t=175737

    The sample should apply to your request as well.

    In brief, you want your record source for your form to have criteria for the field on which you want the form filtered. This criteria will be the control by which you want the form filtered.
    Finally, you just need to add the requery action.
    Corticorp, LLC
    -Development Solutions for .NET, Java, PHP, HTML5, iPad/iPhone, Android and many more
    -Database Development for SQL Server, MySQL, Oracle and others
    http://www.corticorp.com

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com