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 VBA Training and help » Combo boxes in forms and spreadsheets

	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:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Combo boxes in forms and spreadsheets

Resolved · High Priority · Version 2007

ReplyTue 16 Mar 2010, 16:32Delegate Aquila said...

Combo boxes in forms and spreadsheets

Hi

I have a question: I have a combo box in a form. If I select a name on this form combo box, I want it to select the same name from an existing combo box anlready in my spreadsheet. Is this possible and how would I go about writing the code for this?

thanks

For upcoming training course dates see: Pricing & availability

ReplyWed 17 Mar 2010, 11:27Trainer Stephen said...

RE: combo boxes in forms and spreadsheets

Hi Aquila

Thanks for your question

If I understand you correctly you want to select an item from a combo box on a form, and you then want that value to appear in a combo box built into a spreadsheet. If this is the case, then I would suggest writing a procedure that runs on the form's combo box "On Click" event. Simply pass the contents of the combo to a variable, and then set the cell that contains the combo box's value equal to that variable.

Hope this helps

Regards

Stephen

Access articles

· Microsoft Access Mistakes to Avoid
· How To Sort And Filter A Table In Access 2010
· Sub-reports And Sub-forms In Access 2007
· Discover Decisive Details In Your Data, With Access 2010
· How To Understand Access As A Relational Database

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

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

How do i offset the current performance of project to the baseline?

» Forum post: Ms Project 2003

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