Selecting a particular field in a form

[CAM]

Sorry about being long winded on this one.

I have a form that is based on a table that is linked to another database,
which I don't want and can't modify. Within the form the user will input a
policy number into a text box and press the search command button. The
policy number will appear if it exist. Within the form I have a command
button that will append the current policy to another table. Now here is
my problem I may get two or three records of the same policy number but with
different audit types. What I was thinking is to have a check box
(unbound?) to select the policy number with the particular audit type. The
check box is important because I want to append that particular record into
another table using an append query. Within my append query I place this
code in the policy number column based from my form:

[Forms]![frmPolicyUpload]![txtPolicyNumber]

This works fine normally if have a policy number with one audit type, but
if I have two or three audit types of the same policy number all of it will
be appended, which I don't want. I was thinking maybe I can have a query
based on the link table having a temporary column that has a Yes/No format
and somehow tie that into the form using a check box. Just thinking out
load. I know this may sound like a challenge, but if anyone can help or
recommend a website to visit I will appreciated. Thank you in advance.

Cheers

 

[Chris Reveille]

You need to add the chck box to the table.