Unfortunately that didn't work. It is still returning zero rows. However if I choose a named Business Unit, the query returns valid rows for that Business Unit.
I have a database that contains employee information. Each employee belongs to a Business Unit and that Business Unit is described by a number and name. For example: 12345678 and Human Resources. I'm using Access Project and my tables are stored on an SQL Server. I have stored procedures...
I have 2 selection criteria on my form. After making my choice in the first selection I need to refresh the form so that the choices in the second criteria are based on my choice in the first selection.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.