Lookup

Filter combo box

I want to have a drop down list (combo box, or list box or whatever) to display a defined recordset set from a talbe depending on an enter in a field on the same form.

evaluating a range

I am trying to evaluate a formula to return a statement if true. I am having trouble with the syntax. I am working out the number of years service for staff using the formula currentdate-{employment date}/365 What I want to evaludate is whether the result is between 5 and 6. If true I want the...