I can't open expression builder

[JB]

whenever I click on the ... I open the query builder, which i don't know how
to use. is there a way to just open the expression builder?

 

[JB]

I think I figured that one out, now I have a new question. Can I use Dlookup
instead of cascading combo boxes? I have a table called employees and a form
called buy request. Buy request has a field for employee and for phone. I
want the phone field to automatically look up the correct number.

 

[JB]

I have yet another question. In the employees feild on the buy request form,
I only want people's whose job title is purchasing to show up. How could I
use a filter to hide the other employees?

 

[Wayne-I-M]

Base the form not on the table but on a query based on the table. In the Job
Title column of the query put "purchasing" in the criteria row

 

[Wayne-I-M]

If you are looking at a form based on your emplyees table and the phone
number is in this table you can add this field to you form.

or

If you use a combo to look up employees from the table you can add the
telephone number to the combo. Add an unbound text box to your form and use
this is the source
=[combo box name].column(2)

I assume you have ID, name, telephone number in the combo
so the column would be 2 as it starts from 0

 

[Wayne-I-M]

There is no "set" expression builder. Use the box you can see to add
expressons into - you can use the function optons (on the left at the bottom
of the list) to add fuinction and then "build" your expression this way