Using a ComboBox to select a record


show more Using a ComboBox to select a record provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Using a ComboBox to select a record

When you want to change from record to record in a form, instead of having to perform Finds and Filters, there is a quicker way. You can add a Combo Box at the top of the form that will allow you to pick the record from a dropdown list and the entire form will update accordingly. Scroll down to your forms and open up the Customers Order Form. This form shows us all the data from our customers including their orders. To find a customer, I need to go to the Filter button or use the Advanced Filter by form or one of my other techniques. To make it easier let's add a dropdown box right here at the top of the window.

Switch to the Design View. I am going to use the button in the bottom right-hand corner to make the change. First, I need a place to put my button. So I'll click on my Print Current Form and drag it over to the far right. I'll put my box right here. Now here's the crucial detail to make this work. You have to click in this little gray box up in the upper left-hand co...

Using a ComboBox to select a record
Video duration: 2m 55s 3h 43m Intermediate

Viewers:

Using a ComboBox to select a record provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...