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


Software > Access Forms > Passing a varia...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 44668 of 46475
Post > Topic >>

Passing a variable from a form to a query (where criteria)?

by =?Utf-8?B?TWlrYWVsIExpbmRxdmlzdA==?= <MikaelLindqvist@[EMAIL PROTECTED] Aug 8, 2008 at 06:18 AM

Hi,

I've only managed to find bits and parts of how to pass variables between 
forms and queries - but I really need someone to write down a simple
example 
of how to do it - and then I'll modify it from there.

WHAT I TRY TO ACHIEVE

1) In one of my queries I want to filter one of the fields with "or 
<variable1> or <variable2> or >variable3>

These 3 variables should be declared in a form (preferably with a 
radio-button, where I declare "proper" values to variable1...3 if set to
TRUE 
and a "bogus" value to varaible1...3 if set to "FALSE".

I have declared variable1 to variable 3 as variables:

Option Compare Database
Public variable1 As Byte
Public variable2 As Byte
Public variable3 As Byte
End Sub

If someone could explain:

a) How do I get radiobutton1 to write a value to variable1 and
b) how do I call variable1 in my query?

May thanks in advance!

Kindly,
Mikael
Sweden
 




 5 Posts in Topic:
Passing a variable from a form to a query (where criteria)?
=?Utf-8?B?TWlrYWVsIExpbmR  2008-08-08 06:18:01 
RE: Passing a variable from a form to a query (where criteria)?
=?Utf-8?B?S2xhdHV1?= <  2008-08-08 08:08:02 
RE: Passing a variable from a form to a query (where criteria)?
=?Utf-8?B?TWlrYWVsIExpbmR  2008-08-11 05:41:01 
Re: Passing a variable from a form to a query (where criteria)?
"Douglas J. Steele&q  2008-08-11 09:02:40 
RE: Passing a variable from a form to a query (where criteria)?
=?Utf-8?B?S2xhdHV1?= <  2008-08-11 07:20:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Mon Dec 1 21:23:57 CST 2008.