The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Form

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Form

Resolved · High Priority · Version 2003

ReplyTue 28 Apr 2009, 16:51Delegate Xing said...

Form

How to amend combo box? Thanks

For upcoming training course dates see: Pricing & availability

ReplyWed 29 Apr 2009, 16:48Trainer Rajeev said...

RE: Form

Dear Xing

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

Once you have created a Combo box and want to amend it then you can simply go to the design view of the form and click on the combo box.

Choose the Property sheet and on the Data tab choose the Row source you choose the table you want the data to come from.

If you go to the form view you should be able to choose the relevant enter from the Combo list

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

Wed 6 May 2009: Automatically marked as resolved.

Access articles

· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· How To Use The New Total Feature In Microsoft Access 2007/10
· Innovation with Microsoft Access
· How Does The Startup Work When Access 2010 Launches The Northwind Database
· What Are The Benefits Of Publishing Your Microsoft Access Database?

Please browse our web site to find out more about
microsoft.access.courses 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

How do i sub total entries as i fill in spreadsheets

» Forum post: Sum

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions