Share via

Linking a combobox to a subform

Anonymous
2017-11-20T12:57:51+00:00

Hi

I'm looking to link a combo box to a sub form in access 2010.  there are five columns of data in the sub form and the combo box takes the same data that is in the second column of the sub form. in the sub form I want to only display the data that is related to the number picked out from the combo box rather than all the rows worth of data. how would this be done?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-11-20T16:45:58+00:00

    Hi,

    if the combo box is in the main form you can simply set the link properties of the subform control in the main form, i.e. in design view of the main form click once on the subform and in the property sheet set its properties:

    Link Master Fields: [HereTheNameOfYourComboBox]

    Link Child Fields: [HereTheNameOfTheFieldInTheSubform]

    6 people found this answer helpful.
    0 comments
  2. Anonymous
    2017-11-20T16:54:08+00:00

    Hi,

    if the combo box is in the main form you can simply set the link properties of the subform control in the main form, i.e. in design view of the main form click once on the subform and in the property sheet set its properties:

    Link Master Fields: [HereTheNameOfYourComboBox]

    Link Child Fields: [HereTheNameOfTheFieldInTheSubform]

    Hi Karl

    I have done this and comes up with a run time error 2465

    Microsoft access cant find the field referred to in the expression

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2017-11-22T13:26:17+00:00

    Hi,

    it's not clear to me what you have in your subform, i.e. if you use a real form as source object there or just a query. If it is an actual form and if your SQL statement is the record source of this form then try this in the subform's properties:

    link master fields: ToolNumber_Combo

    link child fields: ToolNumber

    0 comments
  4. Anonymous
    2017-11-22T10:41:42+00:00

    Hi,

    you should reveal the name of the combo box and the field name = control source of the control in the subform (not necessarily equal to the control name) and what exactly you wrote in the link properties (paste it in here).

    Hi

    the name of the combo box is ToolNumber_Combo.

    the name of the subform is dbo_NottsWeek28_subform

    there is no control source only row source

    the row source is

    SELECT [dbo_NottsWeek28 Query].ToolNumber FROM [dbo_NottsWeek28 Query] GROUP BY [dbo_NottsWeek28 Query].ToolNumber;

    in the link master fields in data for the subform I have the combo box name and in the link child fields I have the subform.

    also now the subform is blank with no table.

    0 comments
  5. Anonymous
    2017-11-20T17:01:26+00:00

    Hi,

    you should reveal the name of the combo box and the field name = control source of the control in the subform (not necessarily equal to the control name) and what exactly you wrote in the link properties (paste it in here).

    0 comments