Linking a combobox to a subform

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,

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

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,

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.

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

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

Hi,

The data from the subform comes from a form based on a query. so the object source of the subform is dbo_NottsWeek28 Form and the row source of the combobox row source is SELECT [dbo_NottsWeek28 Query].ToolNumber FROM [dbo_NottsWeek28 Query] GROUP BY [dbo_NottsWeek28 Query].ToolNumber;