Results 1 to 3 of 3
  1. #1
    Sparty is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2010
    Posts
    2

    referencing combobox in query

    I have been having trouble updating and referencing a combobox located in a subform. The combobox in question's row source is tied to a query that narrows the users choices based upon a previous entry in another combobox. The query does not work correctly; when you select the combobox, the control reference pop-ups as a null value each time.



    Currently, I referring to the combobox control as [Forms]![Proposal]![Tests subform]![cbotestm], which works when you run the query separate from the form, but doesn't when the query is run through the combobox row source. I have seemingly tried every other syntax I can locate for the control name, e.g. [forms]![Proposal].[form]![Tests subform]![cbotestm], none of which seem to work.

    Thanks for help in advance.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    the syntax to reference a subform control is:

    [Forms]![Proposal].[Tests subform].Form![cbotestm]

    If something doesn't work, then it maybe is not a syntax issue. With comboboxes one must in particular pay attention to the true 'bound' value it contains vs what you search for.

  3. #3
    Sparty is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2010
    Posts
    2
    Thank you for the prompt reply.

    The syntax you provided still isn't resolving the issue unfortunately. I get the same pop-up as if the control reference is null. Both the comboboxes are 'bound'. The cbo I am trying to reference (cbotest) is bound to 'test method', where as the cbo that is trying to query is bound to 'description'. Any other thoughts?

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

Similar Threads

  1. Replies: 29
    Last Post: 08-16-2011, 05:52 PM
  2. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  3. Replies: 0
    Last Post: 12-16-2009, 01:14 PM
  4. How to make A combobox run a query?
    By UnrealEnvy in forum Access
    Replies: 8
    Last Post: 08-17-2009, 11:28 PM
  5. query based on two combobox
    By datto in forum Queries
    Replies: 0
    Last Post: 04-18-2007, 11:10 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