Error 7773: ...can't set the LimitToList property to No right now

Discussion in 'Access Ado Modules' started by GeorgeMar, Aug 28, 2007.

  1. GeorgeMar

    GeorgeMar Guest

    I ahave a List Box that depending on the selection will change the RowSource
    of a Combo box on a form.

    The Combo box sometimes has a query and sometimes is blank.

    In the VBA when there is a query I have
    me!ComboBox1.RowSource="SELECT ..."
    me!ComboBox1.LimitToList=True

    That works fine

    Otherwise
    me!ComboBox1.RowSource=""
    me!ComboBox1.LimitToList=False

    I get: Error 7773: ...can't set the LimitToList property to No right now.

    Any ideas

    Many thanks in advance!
    George
     
    GeorgeMar, Aug 28, 2007
    #1
    1. Advertisements

  2. GeorgeMar

    GeorgeMar Guest

    I've worked out the problem. I am posting this reply for others who may come
    across this error.

    The error "can't set the LimitToList . . ." occurs because it wants the
    Bound Column to be number 1 when the control is set to False.

    In my case there was a condition that set the .BoundColumn=2 and when
    ..LimitToList=False, it stopped with the error. By changing the
    ..BoundColumn=1 it worked OK.

    regards
    George


    "GeorgeMar" wrote:

    > I ahave a List Box that depending on the selection will change the RowSource
    > of a Combo box on a form.
    >
    > The Combo box sometimes has a query and sometimes is blank.
    >
    > In the VBA when there is a query I have
    > me!ComboBox1.RowSource="SELECT ..."
    > me!ComboBox1.LimitToList=True
    >
    > That works fine
    >
    > Otherwise
    > me!ComboBox1.RowSource=""
    > me!ComboBox1.LimitToList=False
    >
    > I get: Error 7773: ...can't set the LimitToList property to No right now.
    >
    > Any ideas
    >
    > Many thanks in advance!
    > George
    >
     
    GeorgeMar, Sep 5, 2007
    #2
    1. Advertisements

  3. GeorgeMar

    Jon Stubberfield

    Joined:
    Oct 29, 2014
    Messages:
    1
    Likes Received:
    0
    Also had same problem. I think the bound column refers to the column number of the field in the table which MAccess is using to get the data from. e.g. if the table you want Maccess to use for the list box has columns ID, Date of Birth, gender then ID would be column 1, DOB column 2 etc. The bound column number should match up with the number of the column that contains the data you wish to store in the new table on your access form.This should then allow you to use the LimitToList "no" option.
     
    Jon Stubberfield, Oct 29, 2014
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. thomas
    Replies:
    1
    Views:
    139
    Ken Snell
    Oct 19, 2003
  2. S.L.

    cnn.mode property

    S.L., Oct 31, 2003, in forum: Access Ado Modules
    Replies:
    1
    Views:
    193
  3. Morten Snedker

    Can't retrieve mdb-table property using ADO

    Morten Snedker, Jun 24, 2004, in forum: Access Ado Modules
    Replies:
    3
    Views:
    155
    ¹Ú¹®¼ö
    Aug 22, 2004
  4. GeorgeMar
    Replies:
    0
    Views:
    150
    GeorgeMar
    Apr 18, 2005
  5. Mona-ABE
    Replies:
    3
    Views:
    274
    Mona-ABE
    Apr 27, 2006
  6. SIS
    Replies:
    0
    Views:
    106
  7. Lisab

    How to set the ODBCtimeout property in code

    Lisab, Apr 2, 2008, in forum: Access Ado Modules
    Replies:
    5
    Views:
    187
    david
    Apr 7, 2008
  8. news.east.cox.net
    Replies:
    4
    Views:
    239
    Douglas J. Steele
    Oct 17, 2008
Loading...