Filtering in Datasheet Subform of Orders

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have orders form with datasheet subform based on Order Details Extended. Have
combo boxes. Cannot filter by selection to narrow specific brands from
manufacturer by choosing manufacturer. (Want to narrow down six fields until
left with only one record and save in the dataset of the subform as a line
item in the order) Do not want to use ProdID because it would be 100
characters long.

Any help deeply appreciated.
 
Try the Filter by Form option, standard in Access, this allows you to select
by any or multiple fields in your form
 
Back
Top