Lost control of Suborm from Main Form

[halfbodyguy]

i dont know what i did, but all of a sudden, while coding some If then
in VBA, I started getting errors while loading.

I use a main form as a filter (combo boxes to set Subform rowsource,
for a lookup) the subform control name is frmMainList

In that Subform there is a List labeled List2

So in the Main forms Combo I have such as:

Private Sub Combo7_AfterUpdate()
[FrmMainList]![List2].RowSource = "QrybySalesman"
End Sub


Which makes it display only the ones that pull up in that query, and
only the ones where the data matches in the combobox and subform
appropriately. I have a few different queries that swap.

They all worked great. then suddenly something broke.

The problem appears to be that the [FrmMainList]![List2] command is not
finding the subform as it should...

Question is: where can i look to see if there is some Subform - Form
link broken... The subform works as it is supposed to. No errors when
it opens... And clearing the OnCurrent for the Main form does Not fix
the errors...

Thanks a lot

 

[halfbodyguy]

A little more Information

The error i have an issue with specifically is whenever I select from
the combo box it should update as above, but i get an AfterUpdate
error.

Also, I had a [FirstName]& " " & [LastName] That should be populated on
its own (textbox)
But it is now coming up error, even though it IS on the selected
record... And they DO show up in the field list...

 

[halfbodyguy]

Solved it. no need to reply. Thanks