 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Combo box WITH free form fill in ALSO
I have a contact database. One form lists the contact info plus payment for the sport they're signing up. I have a PAYMENT TYPE table that lists: Cash, Credit Card, and Check No. While using the form and filling in the payment type for a contact I want to be able to choose CHECK NO but also be able to type in the actual check number next to that option. How do I do this? If you want to store the check no as part of the record, then you should have a field for that in the underlying table with a corresponding control on your form. > I have a contact database. One form lists the contact info plus payment for > the sport they're signing up. I have a PAYMENT TYPE table that lists: Cash, [quoted text clipped - 3 lines] > be able to choose CHECK NO but also be able to type in the actual check > number next to that option. How do I do this? Since I am a new user can you explain, in layman's terms, how to accomplish this? Do I need to have a combo box (for the different payment options...cash, credit card, check) AND also a text box for the check number? How do I put them together? > If you want to store the check no as part of the record, then you should have > a field for that in the underlying table with a corresponding control on your [quoted text clipped - 7 lines] > > be able to choose CHECK NO but also be able to type in the actual check > > number next to that option. How do I do this? Based on the info you've provided, your database should have a table ( named Contacts or something) that stores information about each transaction (name, address, etc.) which is related to the Payment Type table. The "Contacts" table needs a field to store the check number. On your form you need a separate text box where your users would type the check number. You can place it right next to your payment type combo box if you need to. If you unfamiliar with table or form design, I would suggest that you do some research before you attempt to make changes to your database. You could start here http://office.microsoft.com/en-us/access/HA012242471033.aspx > Since I am a new user can you explain, in layman's terms, how to accomplish > this? Do I need to have a combo box (for the different payment [quoted text clipped - 12 lines] > > > be able to choose CHECK NO but also be able to type in the actual check > > > number next to that option. How do I do this? |
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
|
©2009 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.