 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / November 2005Option Group and Later Corrections
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. Is the option group bound the the payment type field in your table? > 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. [quoted text clipped - 10 lines] > > Ray. 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. > Is the option group bound the the payment type field in your table? 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. > Yes, on the payment entry form, the option group is bound to the payment > method field. [quoted text clipped - 11 lines] > > > Is the option group bound the the payment type field in your table? That did it... Thanks, Ray. > What I think I am hearing here is that the corrections form does not have an > option group. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.