Macro to select single record or all records

  • Thread starter Thread starter John Vafis
  • Start date Start date
J

John Vafis

How do I code a macro so that the user has the option to
select a single record (Customer, e.g.) or to select all
records?
 
-----Original Message-----
How do I code a macro so that the user has the option to
select a single record (Customer, e.g.) or to select all
records?
.
set up two queries
Click to expand...
1. Under the criteria if the field you want an single
record selected put ["Enter (FieldName)"]
3. not criteria for the second query
create two macros to run the above queries and attach them
to buttons.
Button 1 - Select single record
Button 2 - Select all records
 
Back
Top