Records not showing until filter selected

WinDancer

Registered User.
Local time
Today, 12:12
Joined
Oct 29, 2004
Messages
290
A form I created contains buttons for the user to restrict the display- showing records that are tasked to one specific employee.
So their choices are Employee a, employee b or all employees.
This is a process I use a lot :)
This last form opens with NO records displayed. When a button is clicked the records show correctly.
Any idea what to check?
Thanks,
 
What is the RecordSource for your form? What code do you have in the Click event of your buttons?
 
OK, this is a bit of a brute-force solution which does not answer the question of why your form is behaving as it is, but it should make it work.

In the On Open event for the form, call the code that's normally called when the ALL EMPLOYEES button is clicked. It should do the same thing as clicking on that button, without all the effort.
 

Users who are viewing this thread

Back
Top Bottom