Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Carrying form n...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 30209 of 30792
Post > Topic >>

Carrying form name through to add to filter in OnOpen event in re****t

by franc sutherland <franc.sutherland@[EMAIL PROTECTED] > May 9, 2008 at 05:17 AM

Hello,

I have a re****t which I filter using the me.filter command in the
OnOpen event.

Me.Filter = "OrderID=" & Forms!variable_form_name![OrderID]
Me.FilterOn = True

I want to be able to open that re****t, filtered, from different
forms.  How do I carry the name of the current form into the
'variable_form_name' part of the filter so that the re****t looks at
the current form to get the OrderID number and complete the filter?

I've tried pulling the form name through using
application.currentobjectname and putting it into a string, but it
didn't like that.

Many thanks,

Franc.
 




 4 Posts in Topic:
Carrying form name through to add to filter in OnOpen event in r
franc sutherland <fran  2008-05-09 05:17:12 
Re: Carrying form name through to add to filter in OnOpen event
fredg <fgutkind@[EMAIL  2008-05-09 09:54:42 
Re: Carrying form name through to add to filter in OnOpen event
franc sutherland <fran  2008-05-13 15:57:08 
Re: Carrying form name through to add to filter in OnOpen event
fredg <fgutkind@[EMAIL  2008-05-13 17:35:43 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 3:14:35 CDT 2008.