Substring input search


The Doctor

Try this again.

I have a combobox field.

This contains records of past work done by the cilent.

The client was a substring search as he is typing in

E.g. wh would produce 4 wheel alignment, wheel alignment, wheel swap ...

rot would produce tire rotation , replace aboveparts,tire rotation et al.

How can this be done in Access 2012 ?

Access Developer

Combo boxes work on a search that begins with the leftmost characters of the
RowSource, not a substring search. You will have to create or simulate a
control similar to a combo box that uses the substring instead. To do so in
VBA, you would probably base it on a combo box, or on a list box with an
additional text box, and write VBA code to re-create the Row Source as each
letter is typed in.

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