Can't find form..?

[Kujen]

Hi all,

I have a mainform with a listbox.
The listbox is supposed to query the subform from a 'after_update' event:
=============================
Dim sfrm As Form
Set sfrm = Forms![FrmSubForm].Form
With sfrm
.RecordSource = "select * from Qry1 where [SalesPerson]='" & Listbox1 & "' ORDER BY SumIntakt_LS DESC"
End With
=============================
The problem is that I get the error: 'Can't find FrmSubForm..'

What can be wrong?

Kent J.

 

[TheAceMan1]

How are ya Kujen . . .

Open the mainform in [blue]design view[/blue], then:
[ol][li]Call up the properties window (if its not displayed already) with the ToolBar button

.[/li]
[li]Select the [blue]Other Tab[/blue].[/li]
[li]Select the border of the subform (selects the subform).[/li]
[li]Have a look at the [blue]Name[/blue] property. This is the name you should be using![/li][/ol]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Kujen]

TheAceMan1,

Thanks.
Now I dont't get the errormessage but I just get one single records with:
Set sfrm = Forms![FrmMainForm]![FrmSubForm]!Form

I have checked my FrmSubForm and it's set to 'continously'

Kent J.

 

[PHV]

what happens if you replace this:
Set sfrm = Forms![FrmSubForm].Form
with this ?
Set sfrm = Me![FrmSubForm].Form

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

. . . or [blue]Set sfrm = [FrmSubForm].Form[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886