Combo Box Help


I have a form that I'm trying to put a combo box on I did the following steps:
Added the field to the table, made it a lookup field, I typed in the data,
(Cash,Check,Money Order, Visa, MasterCard).
Opened my form, created the combo box, went to properties, on “Row Sourceâ€
clicked the eclipse button, added the table, put the field in the query, save
it, named the combo box “txtFilterTypePaymentâ€

But what I get is every entry in the table, I have 400 entries and I got 100
visa’s 200 check’s, and so on --- Will someone please tell me what I'm doing
wrong.

Thanks
 
Ad

Advertisements

J

John W. Vinson/MVP

I have a form that I'm trying to put a combo box on I did the following
steps:
Added the field to the table, made it a lookup field, I typed in the data,
(Cash,Check,Money Order, Visa, MasterCard).

See http://www.mvps.org.access/lookupfields.htm for a critique of the Lookup
Field misfeature. It is NOT necessary to create a lookup field to do what
you ask.
Opened my form, created the combo box, went to properties, on "Row Source"
clicked the eclipse button, added the table, put the field in the query,
save
it, named the combo box "txtFilterTypePayment"

A Combo Box should get data from one table (its Row Source) and put it into
a different table. To be precise, it should put one field - the Bound
Column - into a field of a form's recordsource; the field to use is
specified in the combo's Control Source. You've overridden the lookup field
properties by changing the row source to the target table, so you're drawing
water out of a river and pouring it back into the same river!

Just change the RowSourceType to "List of Values" and type in the few values
you want in the RowSource property, separated by semicolons. I'd suggest
changing the table field's Lookup properties from Combo Box to Textbox, as
it does nothing useful in the table; just use the form combx box properties
instead.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top