I have a single table that contains a claim number field, and a doc type field, that have records. The table also contains a folder number field. I have a form set so that a user enters the claim number, and a Dlookup is done for the doc type, and displays the value on the form. The first field on the form is for the folder number, and the user enters this once for multiple records. How do I perform an update of the record in the table to reflect the folder number, after the user has performed the lookup of the doc type, and found that is valid.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Performing SQL Update with Forms
- Thread starter impulse24
- Start date
Similar threads
- Locked
- Question