syntax for field

[dbertanjoli]

Hello,
My data is coming to my access database from my webform but I would like to have an option for some fields to be altered/changed/added from my access form. So how can I refer to a field in my table? questionID is the field name but in my access form I would like to have several subfields refering questionID 17 (17 is actual ID for a particular record I am refering to), questionID 23.... Do you know what the syntax would be?
Many thanks,

Debbie

 

[pbaldy]

In a SELECT or UPDATE query:

WHERE questionID = 17

 

[dbertanjoli]

But how to do in the form as I would like to extract each question separately so I can change answers if needed, just for particular fields?

 

[pbaldy]

It's hard to give an answer specific to your situation without knowing the specifics of your situation. If you have a form displaying question 17, then you can simply change the data on the form. If you're saying there are several answers related to question 17, then probably a subform displaying the answers, with master/child links keeping the answers in sync with the questions.