Hello,
I am looking for some advice on how to or if this is even possible... Or if im going about this the wrong way all together!
I have a table that contains all data without filters - tbl_HomeOwners Claims
I have a query that I use to filter the table data down to the claims I need to review and then provide me a random sample of claims.
I have a form that is based on the query results. The form has a couple fields to help identify the record which are pulled in from the query - txtClaim, txtPolicyType, txtAdjuster, txtCloseDate
It also has a couple fields that I added to it - cbCoverage, cbAddressed, cbEnsirvio, txtComments. Three are combo boxes and ones a text box. The user will choose from the cbo box and enter any comments based on their audit.
I would like to have the unbound field (cbCoverage, cbAddressed, cbEnsirvio, txtComments) results saved to the tbl_HomeOwner Claims after each audit is completed based on the txtClaim field. Doing this will allow me to identify which claims have been audited.
Is this possible to do?
Thanks for any advice you can privide!