Opening a form

  • Thread starter Thread starter Seamus Dugan
  • Start date Start date
S

Seamus Dugan

I have a table of 260 customers with 30 fields in each
record. After building a query based upon that table's
relationship with three other tables, I was unable to
generate a report that would accommodate all the fields I
needed, so I instead arranged them on a form.

I would like to be able to begin typing the customer name
in that first field and have it complete itself as in an
Excel column(I know, not quite the same thing), and
trigger the fields matching that customer to display in
the form. I could use a combo box, but that would require
scrolling through a list 260 names long, very unsat.

Please understand that the form is strictly to be used to
show existing data, not to enter new records. I do that in
datasheet view.

Thanks for any help you can offer.
 
Use the combo box.
It is very sat.

It is also very smart. Other cbos in other tools only wish they were this
smart.

You get Autocomplete for free.

There are articles on how to handle 10's of thousands of records in a cbo.
Your 260 is extremely small.
 
I could use a combo box, but that would require
scrolling through a list 260 names long, very unsat.
Click to expand...

ummm... not if you use the combo box's capabilities.

If you tab into a combo (or mouseclick into it) and type the letter V
it will jump to the first record with that field starting with V. If
you then type E it will jump to the first name starting with VE, and
so on. Hitting <Enter> or <Tab> will then select the record you've
located.
 
Back
Top