Access Forms

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

Resolved · Low Priority · Version 2003

1 post

ReplyThu 10 Sep 2009, 14:33Delegate Adam said...

Adam has attended:
Access Intermediate course
Excel VBA Intro Intermediate course

Access Forms

How do you make a combo box on a form control the whole form in such a way that it would bring up related fields to the contents of the combo box?

For example, i want to select the Names of people that work at my company from a combo box. I want this then to trigger all other fields that i choose, ie. age, address, job title etc.

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2003	Thu 19 Aug 2010	Southwark	4		£240	£245	£245
2007	Thu 26 Aug 2010	Southwark	5		£240	£245	£245
2010	Fri 17 Sep 2010	Bloomsbury	9		£225	£230	£299
2003	Fri 1 Oct 2010	Bloomsbury	8		£218	£223	£245
2003	Mon 8 Nov 2010	Southwark	9		£162	£167	£245
2010	Thu 25 Nov 2010	Bloomsbury	10		£150	£155	£299
Full Schedule: See all 24 Access Advanced course dates. Bookings currently available until 30th September 2011.

825 posts

ReplyFri 11 Sep 2009, 11:13Trainer Stephen said...

RE: Access Forms

Hi Adam

Thank you for your question

Create your combo box in the normal way by drawing it on the form. Make sure that control wizards are switched on (Magic Wand button on the control toolbox)

The wizard will ask you which type of combo box you want, and the third entry is to select a record based upon the combo box value. Select this and click next and then the wizard will guide you through the process, asking you to specify the key filed etc.

Regards

Stephen

Fri 18 Sep 2009: Automatically marked as resolved.

· Getting To Grips With Templates In Access 2007
· Why go on a Microsoft Access Training Course?
· Be Top Of The Form With Access 2007
· Supersizing your databases via Microsoft Access
· Turning your Spreadsheets into Interactive Data Warehouses with MS Access Courses

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

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips