Access 2007 Form

[rizabdullah]

Hi Guys

I have a make table query, on which I have created an additional field called COMMENTS. I would like to update COMMENTS field on this table via form depending on other other dropdown criterias on the form. Hope I am clear and you can help

Many thanks in advance.

 

[pbaldy]

Not overly clear, but why not just bind the form to the table so you're updating the desired record directly? Failing that, an update query using the dropdown criteria should work.