Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

combo box forms

ResolvedVersion 2003

Combo Box/ Forms

Hi Guys,

In a form I use to list details of my company's clients, I have used a combo box to scroll through the records to find a particular person. I want this box to use 'predictive text' so that as a user types a surname (or first name) the possible names appear in a drop-down box. How can this be done?

Thanks,

Andy

RE: Combo Box/ Forms

Hello Andy

Thank you for your post, we do believe that a solution can be found for this with some VBA code but it is beyond the scope of this forum.

We would need to see your working files and if a solution presented itself we would let you know related time and costs to do this. If you were then interested in proceeding we would formalise a consultancy agreement.

If you want to continue looking for solutions yourself it might be worth checking out the following article:
http://support.microsoft.com/kb/208786

Kind regards

Jacob

Wed 7 Jul 2010: Automatically marked as resolved.

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.