Value holder on form

  • Thread starter Thread starter gianni_sacco
  • Start date Start date
G

gianni_sacco

Aghhhh! I know this is a dummy question but it's kicking
my butt!

What, oh WHAT can I do in order to store a static
reference value on a form?

I'm trying to create a standard input form for our
salespeople. They'll all be hitting the same tables but in
numerous instances I want the salesperson in question to
be able to see ONLY the records pertinent to him -- in
other words, those records which contain his SalespersonID.

So, I'm going to roll out a front end to each salesperson,
which will contain this form. On each salesperson's form,
I'm trying to store the SalespersonID statically in an
invisible text box on their form, and then use that
SalespersonID as a reference parameter for the query that
provides the data source for the form.

But, the query won't recognize anything in the textbox!

How do I store a constant value in a form for reference by
a query? Thank you!!!
 
Why not use a local table? Or you could also use a global variable or
a property of the form.

Peter
 
Back
Top