Combo box WITH free form fill in ALSO

[tjsmags]

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?

 

[Beetle]

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.

 

[tjsmags]

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?

 

[Beetle]

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