Change Field in a query by form

[mousemat]

Is the a way of changing the fields selected in a query by a form.

I have a form showing how many people need to do each module. Each textbox is populuted by a count from the table.

The idea is simply to avoid having 26 queries based on each module. Is there a way to have the field name changed via the form.

I have used the on dbl click event to pass the field name to a hidden field on the record. I just need to pass the data in the hidden field to the select query.

 

[RV]

Most likely not the reply you're after, but you really should start normalising your structure.
Otherwise, you'll end up having to use rather complicated and messy VBA

Referring to my reply in one of your previous threads:

http://www.access-programmers.co.uk/forums/showthread.php?p=510783

RV

 

[mousemat]

Thanks for your advice RV.

Im more than happy to work with messy vba so if anyone has any idea, i'm more than willing to take them