I'm creating an expense database and I already have a good amount of the form and query work done, however I'm having trouble with a particular form. I've set the form up so that when you enter an employees ID # you see their expenses for the month. The problem is that not all employees incur expenses...when you type in one of these employees numbers the data from the previous record remains. How can I get the form to show nothing if there are no expenses for a given individual.
bye the way, the form is set up with a subform table which contains all the data.
bye the way, the form is set up with a subform table which contains all the data.
