Convert the user input as a field name in an update statement

[nina1]

I have a combo box as a month selection. Combination of the combo box selection and a fixed word like "Alum" would be my field in a table to update. For example my current selection is "JUl" and I would update the field "AlumJul" in a table.Something like this.

Update Cost set AlumJul=combo2.value where type=LME

I just can't set AlumJul as a field to work.

Thanks

 

[PHV]

You REALLY have fields with monthname ?
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886