F
FrunkaBlunka
Hi everybody,
I have been trying to work out the easiest way to display certain
records only. In my database I have a toggle button that once pressed
indicates the record/project has being invoiced. Once a project has
being invoiced I would like it to hide itself from selection when
navigating through the database.
Easy enough! I made a query and it works fine but what if I wanted a
toggle button for the whole database so that when its in its down state
it displays all records including the invoiced ones and when in its
upstate shows uninvoiced projects only?
I want to do this with affecting the input for the invoiced button
cause it is important to the overall structure.
My Main form is called frmProject which gets it data from a query
called qryProject.
Thanks
Blunka
I have been trying to work out the easiest way to display certain
records only. In my database I have a toggle button that once pressed
indicates the record/project has being invoiced. Once a project has
being invoiced I would like it to hide itself from selection when
navigating through the database.
Easy enough! I made a query and it works fine but what if I wanted a
toggle button for the whole database so that when its in its down state
it displays all records including the invoiced ones and when in its
upstate shows uninvoiced projects only?
I want to do this with affecting the input for the invoiced button
cause it is important to the overall structure.
My Main form is called frmProject which gets it data from a query
called qryProject.
Thanks
Blunka