Filter a form by a range on numbers

  • Thread starter Thread starter Erin Freeman
  • Start date Start date
E

Erin Freeman

Hi there,
Here is the situation.
I have a table with catalogue numbers.
I have query based on that table
I have a form based on that query.

I need to be able filter by a range of catalogue numbers in order to print
that range and not just one by one. Any help would be appreciated.
Thankyou
 
Thanks,

I want to activate the code when a button is clicked this is what i have
Call DoCmd.OpenForm("Frm_ArtifactCard")

Dim f As Form
Set f = Forms("Frm_ArtifactCard")


Me.Filter = "([BagNumber] => [Please Enter First Value) And ([BagNumber] =<
[Please enter 2nd value])"
Me.FilterOn = True

it opens the form but the text boxes dont pop up to allow the user to
specify the range



Dymondjack said:
I think you should be able to use the form's filter property to accomplish
this.

Me.Filter = "([fieldname] > 10) And ([fieldname] < 20)"
Me.FilterOn = True

I don't use this much myself, the syntax may not be 100% correct, but it
should at least give an idea. The above example would return records
numbered 11 through 19. Ideally...


hth
-jack



Erin Freeman said:
Hi there,
Here is the situation.
I have a table with catalogue numbers.
I have query based on that table
I have a form based on that query.

I need to be able filter by a range of catalogue numbers in order to print
that range and not just one by one. Any help would be appreciated.
Thankyou
Click to expand...
Click to expand...
 
Back
Top