sub form question

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

I have this sub form on my Main Form frmMain
how do I recode this now that it is on my main form?

Forms!frmsubDisList![lstModify] = Null
Form_frmsubDisList.lstModify.Requery
 
On Sat, 13 Feb 2010 15:09:38 +1300, "Bob Vance" <[email protected]>
wrote:

Your message is a bit cryptic to me, but I think you mean you want to
interact with your listbox in the subform from your Main form.
If so, then write this:
Me.mySubformControlName.Form!lstModify = Null
etc.
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP
 
Thanks Tom, What if I was requering it from another form how would I code it
frmMain subfrmDisList lstModify
Thanks Bob

Tom van Stiphout said:
Your message is a bit cryptic to me, but I think you mean you want to
interact with your listbox in the subform from your Main form.
If so, then write this:
Me.mySubformControlName.Form!lstModify = Null
etc.
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP

I have this sub form on my Main Form frmMain
how do I recode this now that it is on my main form?

Forms!frmsubDisList![lstModify] = Null
Form_frmsubDisList.lstModify.Requery
Click to expand...
Click to expand...
 
Hi Bob,
What if I was requering it from another form how would I code it
Click to expand...

Instead of using the "Me" keyword, use [Forms]![NameOfYourParentForm]

Try this:
[Forms]![frmMain]![mySubformControlName].Form!lstModify = Null


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

Thanks Tom, What if I was requering it from another form how would I code it
frmMain subfrmDisList lstModify
Thanks Bob

__________________________________________

:

Your message is a bit cryptic to me, but I think you mean you want to
interact with your listbox in the subform from your Main form.
If so, then write this:
Me.mySubformControlName.Form!lstModify = Null
etc.
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP
__________________________________________

:

I have this sub form on my Main Form frmMain
how do I recode this now that it is on my main form?

Forms!frmsubDisList![lstModify] = Null
Form_frmsubDisList.lstModify.Requery
 
Thanks Tom That did the trick..Regards Bob :)

Tom Wickerath said:
Hi Bob,
What if I was requering it from another form how would I code it
Click to expand...

Instead of using the "Me" keyword, use [Forms]![NameOfYourParentForm]

Try this:
[Forms]![frmMain]![mySubformControlName].Form!lstModify = Null


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

Thanks Tom, What if I was requering it from another form how would I code
it
frmMain subfrmDisList lstModify
Thanks Bob

__________________________________________

:

Your message is a bit cryptic to me, but I think you mean you want to
interact with your listbox in the subform from your Main form.
If so, then write this:
Me.mySubformControlName.Form!lstModify = Null
etc.
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP
__________________________________________

:

I have this sub form on my Main Form frmMain
how do I recode this now that it is on my main form?

Forms!frmsubDisList![lstModify] = Null
Form_frmsubDisList.lstModify.Requery
Click to expand...
 
Back
Top