Use form to Update Data Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database which will store audit procedures for use in our
business. One table will store the master audit procedures and details about
each step such as the department audited etc. The other table will be used
to enter the results of the audit tests performed. The audit reference
number will be the common field which will be used to connect the two tables.
I have created a form that the users can use to enter audit procedures into
the master table. I want them to be able to select an audit section
(Investments) and have the database update the audit section with a "C". The
reason for this is that the auditors can't remember the section letters as
good as they can the seciton names. This way, they can just select the
section name and the database will populate it with the letter, which is
really what is needed.
I was able to create a text box on the form which retrieves the letter, but
I can't seem to get it to update my table. Any help would be much
appreciated. I am new to Access and just want something that works, it
doesn't have to be fancy.
Thanks.
 
I am creating a database which will store audit procedures for use in our
business. One table will store the master audit procedures and details about
each step such as the department audited etc. The other table will be used
to enter the results of the audit tests performed. The audit reference
number will be the common field which will be used to connect the two tables.
I have created a form that the users can use to enter audit procedures into
the master table. I want them to be able to select an audit section
(Investments) and have the database update the audit section with a "C". The
reason for this is that the auditors can't remember the section letters as
good as they can the seciton names. This way, they can just select the
section name and the database will populate it with the letter, which is
really what is needed.
I was able to create a text box on the form which retrieves the letter, but
I can't seem to get it to update my table. Any help would be much
appreciated. I am new to Access and just want something that works, it
doesn't have to be fancy.
Thanks.
Click to expand...

Simply use a Combo Box on your form. It can easily be set to have one
value in its bound column (the "c") and a different value in its first
visible field (the name of the section).

You'll probably need (if you don't already have) a small two-field
table with the audit codes and their corresponding section names; base
the combo on this table (or a sorted query of the table).

John W. Vinson[MVP]
 
Back
Top