Combo box WITH free form fill in ALSO

[Guest]

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?

 

[ajetrumpet]

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?

Can you put another text box in the form and add another column to the table?? Why not?

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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

 

[ajetrumpet]

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?

Here it is in laymen's terms....

Yes, you should probably insert a combo box for your three payment choices.

Insert a textbox next to the control (whatever it is, combo box, list box, etc...) where you enter the choice called CHECK. In the properties for the text box under the DATA tab in the "control source" box , type the field of the table where the data you enter will be stored. So, if in your table called PAYMENTTYPE, you have fields called CHECK and CHECK NO., type [PAYMENTTYPE.CHECK NO]. If the form you're using is already based on the table, the drop down menu in the control source box should list the current fields in the underlying table for you to choose from. Now that you have that set up, any check numbers you enter in this text box will be stored in your table under the new field you created....