I've looked back to August 2009 and didn't see an answer...I am still looking, but I thought I'd ask the question.



I am trying to build a 'suggestion' program based on a query. The result set of the queiry is a linking code (area, section, sub-section and question number, (each it's own field) the question, a response, and a numeric identifier of the person responder.) The main form contains everything up to the question. The reason this is on the main form is that there may be multiple responders to the same question.

The subform has the response (or blank) and using dlookup, the information of the responder. The responder_id will be a hidden field. So far, this appears to work for getting the data out.

However, also included on the subform is an 'add response' button. the INTENT of this is to go to a new record, populate the responder fields (and responder_ID) based on the value in TempVars, position the cursor in the response, and accept the new response (including the linking data of area, section, subsection and question number)

Any chance of this working? and if so...how?