Problem updating subform via onchange of textbox

[pds8475]

Got a weird problem with my form FrmAddDueIn.

I want to create a OnChange event on the textbox NumberTxt that updates the subform ATRRecordQuerySubform.

My problem is that the form for an unknown reason will update the subform based on NumberTxt value and the value of the combobox Customer.

When I run the query ATRRecordQuery or the subform ATRRecordQuerySubform on their own they just ask for NumberTxt value.

So the problem has to be on the main form FrmAddDueIn.

I have attached a copy with the relevant forms, queries and tables.

Any help would be much appreciated.

 

[Uncle Gizmo]

It sounds like your subform is based on the query and the query is picking up information from the controls on the main form.

 

[pds8475]

I have found it. It seems to be because the combo box used to select customers was called customer and it seems the query when ran from the main form was using that control instead of the table field customer. Renaming the control to CustomerCombo sorted it. Luckily there wasn't much of the VBA that accessed it.