Access 2007 Totally Different

[tacomabd]

Does anyone know if there is a help screen where you can find things? It is a disaster trying to find what I want. I new where everything was in 2003, but this is messed up.

[kimmer]

Click "Start the Guide"
http://office.microsoft.com/en-us/ac...388991033.aspx

[tacomabd]

Thank you very much. I think this is what I am looking for.

Bob

[kimmer]

Bob, one of favorite things about 2007 is something I never see mentioned anywhere.
In Layout View of a form, the field list can display not only fields from the table at hand, but also fields from tables that have a relationship with the table at hand.

To create a combo box, drag a field onto the form and Access makes it an appropriate drop-down.

For example, drag DepartmentName onto the Employees form, and you will get a combo box that stores DepartmentId but displays DepartmentName.