RE: Update table data

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thank you for your replied.

I already 90% of the fields were combo boxes. Any other suggestion?

"Duane Hookom" wrote:

Perform all of your data interaction in forms where you can use a combo box
for the CommissionPaid field.

--
Duane Hookom
Microsoft Access MVP


"hoachen" wrote:

I create a table that have a column name "CommissionPaid", and three options
selection from a form: 1-Yes, 2-No, and 3-NA. When the data is enter, it
automatically insert into table for, 1 or 2 or 3 (name: CommissionPaid). It
is difficult to understand after awhile what 1, 2 and 3 means after many
radio button and checkboxes. I want to make it easy to read in the future by
"Yes" or "No" or "NA" in the CommissionPaid column instead of value 1,2 or 3.
I am think using the update query and the link the field and update
automatically after the selection is selected. I have tried but unsuccessful
:( Is there any example or better solution to this?
Thank you anyone try to help
.

Quantcast