Not sure if this is possible but I figured I'd ask.

I currently have a form/update query that allows me to change a persons last name in a record depending on the value I enter in an unbound text box on the form.

Is it possible to make this query dynamic so I change field names on the fly instead of it programmed for lastname. Example, I want to change firstname instead of lastname.

Would I need another query for firstnames?

Anybody???

Yes you could do that. Are suggestion something like adding a combobox to the form and having the user select a field from the combo box and then update it to what they have typed into the textbox?

Thats exactly what I'm trying but I can't figure it out.