UNBOUND fields in a bound CONTINOUS form?

[Dennis]

I have a continuous form bound to a query. I have locked the fields from the
quesry, and added a frame (Yes, No, N/A answers), and a COMMENT text-box.
These controls are NOT tied to the table supplying the form. I want to be
able to independently answer each Frame question and each Comment
individually, so they relate to the specific question. The answers will go
into a separate table.

When I click on the Frame choice, ALL records in the subform instantly
change to the same selection. Also, when I enter comment text, all the
records also change to the same text. Again, I need to be able to have
independent answers to the Frame, and independent comments, for each record
on the continuous form. I would LIKE to have a single "Post Answers" button
in the form footer, to trigger a table-write of all previous entries.

Again, the data FROM the initial table is fixed. It is a series of questions
that I need to answer. The answers MUST go in a separate table.

Any ideas how I can do this?

Thanks!

 

[Dennis]

One more thing: when I TAB (exit) from the last (unbound) field in a specific
record, I want to go to the next record's field.

 

[GaryS]

Dennis,

I'm no expert, but why don't you just make another query using the initial
query and the comments table (related 1 to 1) and base your form on that
query. That way the comments will go into the appropriate table.

 

[arthurjr07]

try to recreate a dummy table. with the same field with your query +
fields for frame and comments. Bind your continous form to that dummy
table.

on the form load event, Then transfer all the records in the query to
the dummy table.

 

[Dennis]

I ended up doing that (kind-of). What I did was check to see if the required
records were in the second table. If not, I populated the table with
"default" records. Then I opened the form and allow the user to, in effect,
modify the newly-present default fields. Worked like a charm.