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 ..."

    That works fine


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

    Any ideas

    Many thanks in advance!
    GeorgeMar, Aug 28, 2007
    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.

    GeorgeMar, Sep 5, 2007
    1. Advertisements

  3. GeorgeMar

    Jon Stubberfield

    Oct 29, 2014
    Likes Received:
    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
    1. Advertisements

Ask a Question

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.