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.

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.1 secs.