Getting to a list box on subform????

[d9pierce1]

Hi all,
I have a primary form with a sub form that I switch tabs on to open different forms and I cant get to this one field for some reason?
I think I need to call it somehow but here is what I have..
[CODE]
[CODE]Private Sub CmdReset_Click()


' Call ClearList(Forms!frmProjectHolder!sfrmProjectTeam.F orm!LstMemberRoles)
End Sub

Primary Form is frmProjectHolder
Sub Form is sfrmProjectTeam
The ListBox is LstMembeRoles which is on a form frmProjecReport
I beleive there is a way but I cant remember how to enter it??? See Below

Private Sub CmdReset_Click()
Call ClearList(Forms!frmProjectHolder.sfrmProjectTeam.frmProjecReport.Form!LstMemberRoles)
End Sub

Of course this didnt work and would love some assistance in the correct syntax to get this to work please
The data base is 20mb so I really cant post it without removing most of it, sorry

Thanks
Dave

[moke123]

Is it a single selection list box or multi-select?

Do you just want to de-select the list or clear it's rowsource?

Is clearlist() a sub?

[CJ_London]

Private Sub CmdReset_Click()
Call ClearList(Forms!frmProjectHolder.sfrmProjectTeam.f orm.frmProjecReport.Form!LstMemberRoles)
End Sub

looks like you are missing a .form

[orange]

Dave,
This is a standard reference for form/subform... by Dev Ashish.

Sounds like you have a Mainform and 2 subforms.

[d9pierce1]

Hi all,
I have tried the following with errors....

Call ClearList(Forms!frmProjectHolder!sfrmProjectTeam.Form!frmProjecReport.Form!LstMemberRoles)
Error Cant find the field frmProjectReport - Not a field, its a form


Call ClearList (Me!sfrmProjectTeam.Form!frmProjecReport.Form!LstMemberRoles)
Error cant find fiels sfrmProjectTeam - Not a field, its a form

[d9pierce1]

Call ClearList(Forms!frmProjectHolder.sfrmProjectTeam.F orm.frmProjecReport.Form!LstMemberRoles)

object define error?

Not sure why the space is after F orm as that is not how it is when in edit mode! Just on this site\

[d9pierce1]

Hi Moke
It a multi select list box
It has a clear list module to call on, but never had this issue before using it. Works fine and all I can think is it needs to get to a second subform to reconize it?
Dont know

[d9pierce1]

Not real sure what I did but got them working?
So closing this out!
Thanks all,.
Dave

[June7]

The funky space is thrown in by forum - don't know why. Put text within CODE tags and space won't get thrown in.

[Welshgasman]

Not real sure what I did but got them working?
So closing this out!
Thanks all,.
Dave

See you back soon then.

[d9pierce1]

Thanks all,
I deleted all the code for the two buttons and put it back in and it went thru fine and works great?
Must been a stuborn error of some kind!
All is good and see ya soon!
Dave