MS Access forms using a variable to run a query

Question

Can you pass a variable to a query which will populate a combo box? If so, how?

Community · Accepted Answer · 2017-05-23 12:20:18Z

1

You can set the row source of a combobox in a number of ways. For example, you could include the following in the current event:

 Me.ComboX.RowSource = _
    "SELECT ID, Description FROM Table WHERE AText='" & MyVar & "'"

Alternatively, you can refer to a form in code or in design view:

 SELECT ID, Description FROM Table WHERE AText=Forms!AnOpenForm!AControl

CommunityBot

11 silver badge

answered May 23, 2012 at 11:57

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1