First off is the UserId the same as their login username? If so you could
use the function here to retreive their login ID.
http://www.mvps.org/access/api/api0008.htm
Then based on that you could have the code fill the form with what you want.
Lets say your basic query is something like
SELECT * FROM Table ORDER BY DateField
then on open of the form you could do something like
Dim strSql as string
strSql = "SELECT * FROM Table WHERE UserID='" & fOSUserName & "' ORDER BY
DateField
Me.Form.Recordsouce = strSql
If the fOSUserName doesn't return the right UserID then you could use an
input box or something but hopefully you get the idea.
Tony
"Jason Lopez" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I have a basic Access Data Page designed where all pertinent information is
>displayed for the overall. However, based on the person who is reviewing
>the information, how do I filter out the irrelevant information from the
>page without creating a seperate query for every single person?
>Essentially, I am thinking of some type of dialogue box that will display
>before displaying the page of information. That dialogue box will ask for
>the userid of the person seeking the information and then match that up
>with the relevant information. Then only the information attached to the
>userid is displayed.
>
> Is there a way to do that in an Access Data Page?
>
> Jason Lopez
>
Similar Threads
