I am a ROOKIE with Access and I have a field that is used for inserting data (Advertiser Name "AN"), and a following field that includes a pivot table that is used to select the (Category of Advertiser) from a list of selections.
The (AN) field does not hold a query because It is used to list new (AN) data
Is it possible to develop a macro that will search the (CofA) pivot table for any full word match in the field(AN)
Hence, doing an automatic search for relative values so that I don't have to search manually in the pivot table?
Would Appreciate any help or advice
Thanks in Advance
Sean
The (AN) field does not hold a query because It is used to list new (AN) data
Is it possible to develop a macro that will search the (CofA) pivot table for any full word match in the field(AN)
Hence, doing an automatic search for relative values so that I don't have to search manually in the pivot table?
Would Appreciate any help or advice
Thanks in Advance
Sean