Auto Populated fields from a form

[dcrqueens]

Hello All,

The following fields in my form are linked to a combo box so that they
can auto populate:

Name
State
Review Date
Review Total

I am now trying to create a report based on the same query I used to create
my form. I now realized that auto populated data (from the form) is not
stored in the field names above because they were unbound text boxes. So my
question is when you are doing auto populate is there a way to make the
information save into the table so that it can be viewed in my report?

Thank you in advance

 

[Marshall Barton]

The following fields in my form are linked to a combo box so that they
can auto populate:

Name
State
Review Date
Review Total

I am now trying to create a report based on the same query I used to create
my form. I now realized that auto populated data (from the form) is not
stored in the field names above because they were unbound text boxes. So my
question is when you are doing auto populate is there a way to make the
information save into the table so that it can be viewed in my report?

That's not the way to deal with it. You should always look
for a different way to do things instead of storing
redundant data in a table.

In this case, the standard approach is to use a query for
the report's record source. The query needs to Join the
combo box's table to the report's table on the field bound
to the combo box.

 

[dcrqueens]

Marshall you are absolutely right. I went back and did what you said and
everything is working. Thank you for your help.