combo box forms
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Combo Box/ Forms

Combo Box/ Forms

resolvedResolved · Urgent Priority · Version 2003

replyReply Mon 28 Jun 2010, 19:01Andy (guest) said...

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

For upcoming training course dates see: Pricing & availability

replyReply Wed 30 Jun 2010, 12:55Trainer Jacob said...

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.

 

Please browse our web site to find out more about
access course and other Microsoft training courses.

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard