Microsoft Access 2007 tutorial: Lookup wizard

Lookup wizard

IX. Lookup Wizard

This wizard creates a lookup column, which displays a list of values you can choose from when you enter data into a table.

IX.1. Creating Value List Lookup Wizard

Value List Lookup wizard allows you to enter the values that you want them to display in Value List when you click lookup column. For instance, in tblemployee, sex field, you want to define F for female and M for male for choosing when you click column. To do so follow the instruction below:

- Open TblEmpoyee in Design View as figure:

Microsoft Access 2007 Lookup Wizard

- Where field sex click Lookup Wizard as figure above

Lookup Wizard dialog box appears:

- Choose the option as figure below

- Enter F and M values in the list

- Enter lookup column name --> Finish

Finally, Open TblEmployee to check the result

Note: Name of lookup wizard field is optional.

IX.2. Creating Lookup Wizard by Retrieving Data from a Table or Query

This wizard allows you to take the values from existing field of table or query. For example, you want to get F and M values from existing sex field of TblCustomer. To implement example above do the following steps:

- From step one to three do the same creating value list lookup wizard

- Select this option

- Select TblCustomer table from the list

Microsoft Access 2007 table list

- Click Next and Select fields

Microsoft Access 2007 select fields list

- Click Next and Sort record as a figure

Microsoft Access 2007 sort record

This dialog box allows you to sort records in ascending or descending order.

Note: The sorting records is optional.

- ClickNext and click Finish

Finally, Open TblEmployee to check result.

Posted comments

Patrick:

Good explanations. Thank you :)

03-22-2013

Dara:

Global and local variables declaration example:
http://www.worldbestlearningcenter.com/tips/Global-variables-in-vba.htm

02-23-2013

ann:

thanks for sharing your knowledge it helps me a lot.

02-11-2013

Tamilan:

Pls post some examples for declaring and calling variables (local and global)

02-09-2013

M.somjate:

Thanks for example color code.

02-08-2013

G G Shah:

Heartly Thanks.God bless you.

01-18-2013

sek sam:

I like this website very much.
It has a lot of helpful helpful materials to learn excel programming.

01-01-2013

limocky:

useful ms access examples...
good web site to to learn access from scratch.

01-01-2013

bakery:

Thank for useful VBA example code...

12-27-2012

prasat:

Thank u for useful website..

11-03-2012

zal:

Thank for really helpful posts

10-28-2012

brasha:

Useful VBA examples for Excel. I really need them.

10-25-2012

.........................................................................................................................	Home \| Forum \| About \| Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.