information save does not go to the corresponding record

G

Guest

I have created a form, which a certain control has the characteristic that
all information saved in this control for every record does not go to the
corresponding field in the table. The information saved for this particular
control appears in a new field in the table by itself. What can I do to solve
this problem.
 
R

Rick B

The information is saved in a new FIELD in the table by itself? Your table
definition is changing? Or a new RECORD in the table?

If you pull up a record in a form and modify that record, then the data will
be saved to that record. If you pull up a form with a blank (new) record
and enter data, that will create a new record.

If you have any code associated with your form, then that could make a big
difference. You'd have to share that with us though.
 
G

Guest

Rick:
I have 2 forms. One that is the main form, and one form that I will call the
"new form". The "new form" opens and shows a set of questions when the anwser
is "yes" from the main form of one control that has a "check box". When the
answer "yes" is chosen, then this forms open, otherwise not, but the
information from this set of questions (the new form) does not save the
information in the corresponding field in the table. It actually saves the
information in a new field of the table. In other words, all the information
from the "new form" is saved in a field, and everything else is saved in
another field. I have created macro that makes the "new form" appear, but all
the controls belong to the same table. I hope this helps.
Regards
Miguel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top