Option Group and Later Corrections

[Guest]

I have created a payments entry form using the Option Group. The Options
Group assigns 1 to the table for Cash Pmts and 2 for Check Pmts.

As a result of user error, I am creating a corrections form so that the user
can pull up all of the payments for a particular person and make the
necessary corrections to a payment. The only problem I am having is
figuring out how to allow for corrections on the payment method.

How Do I keep this simple for the user by choosing either a Cash or Check
and still having a 1 or 2 changed in the database?

Thanks,

Ray.

 

[Guest]

Is the option group bound the the payment type field in your table?

 

[Guest]

Yes, on the payment entry form, the option group is bound to the payment
method field.

On the Payment Modification form, I want the user to be able to modify the
payment method, i.e., the customer actually paid via cash and the clerk
accidently entered that the customer paid via Check.

How do I do this while keeping the form user friendly by saying "Cash" or
"Check" and still entering a 1 or 2 (based upon the correction) in the table.

Thanks,

Ray.

 

[Guest]

What I think I am hearing here is that the corrections form does not have an
option group. Is it, possibly, a datasheet view? If so, you can open the
form in design view, right click on the text box for the payment type and
select change to. An option group is not available, so I would use a combo
box. Once you have changed to a combo box, make it 2 columns with column 1
being the bound coulmn, make the row source type a value list. In the row
source property
"1";"Cash";"2";"Check"
Make the column widths 0",.5" This will make the 1 and 2 invisible. The
user can select cash or check and the corresponding values will be updated in
the table. It will also show the current value as eithe Cash or Check.

Post back if you have more questions.

 

[Guest]

That did it...

Thanks,

Ray.