Search by field name

[Xenix]

I have a form where I select a product via a combo box and it returns a field reference label, e.g. prod1, prod2 etc.
there are field names from prod1 to prod68

Now I want to write some code that will do a search for any customers that have a tick in the boxes under what product group I select from my combo box.

Any ideas?

 

[Rich]

I'd say you have a design problem if you really have seperate fields for each product. Is that what you meant?

 

[David R]

You're receiving divided help because you've posted this question twice. More help has been offered in your other posting so I suggest you check back there: http://www.access-programmers.co.uk/ubb/Forum4/HTML/005707.html