DS range

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I have a table with Alpha client ID. I have a datasheet form that opens
displaying records starting at "A". What would be the best way to display a
range of clients if I wanted (maybe C to L), and all (A- Z) of them if I
didn't want a range. I think I could create a query that might work but
would that be the best way? And for the "all" option, could that be set up
with out having to put in AAA / ZZZ in two fields?
thanks.
 
Look in VB Help for the OpenForm method. I think if you read info on the
Where Condition argument it will get you what you want.
 
Rob,

Put 2 unbound textboxes on a form, where you can enter the starting and
ending letter of the range you want to see. Base the data form on a
query, and in the criteria of the field in question, put the equivalent
of this...
Like "[" & Nz([Forms]![YourForm]![StartLetter],"A") & "-" &
Nz([Forms]![YourForm]![EndLetter],"Z") & "]*"
 
Back
Top