Find / Search on a Form

The UK's most regular instructor-led training courses.
Training information: access class ms training · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Medium Priority · Version 2007

2 posts

ReplyMon 8 Jun 2009, 14:56Delegate James said...

James has attended:
Access Intermediate course

Find / Search on a Form

When searching on a form, I would like all the entries to be listed in a drop downbox so that as I type in the number I am presented with correct entry without having to type in all the numbers.

Thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	5		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

870 posts

ReplyTue 9 Jun 2009, 07:13Trainer Rajeev said...

RE: Find / Search on a Form

Dear James

Thank you for attending Access 2007 Intermediate course!! I hope you enjoyed the course and benefited from it.

Am I right in thinking that you want to choose an entry from a drop down list and depending on the entry the data changes in your form?

please refer to the following link that provides the answer to this:

http://en.allexperts.com/q/Using-MS-Access-1440/Combo-box-find-specific-2.htm

if you question was more about Autocomplete in the combo box then please refer this link:

http://en.allexperts.com/q/Using-MS-Access-1440/2009/4/Auto-Fill-2.htm

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

· Learn about Subqueries in Access Courses
· So You Still Haven't Learned How To Use Access Yet?
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Some Simple Database Questions Answered
· Supersizing your databases via Microsoft Access

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

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips