I have a pass through query that executes a store procedure that shows the personnel ID number of the person logged in. The personnel Id number is retrieved from a personnel database that we have in existence.
The query works fine and retrieves my pers Id ok.
I now need to have that result compared to a field on a record to check whether they match, if they do certain parts of the form are then made visible.
Basically:
If Log In PersId = record PersId then
Then display other text boxes on the form.
cheers
Dave
The query works fine and retrieves my pers Id ok.
I now need to have that result compared to a field on a record to check whether they match, if they do certain parts of the form are then made visible.
Basically:
If Log In PersId = record PersId then
Then display other text boxes on the form.
cheers
Dave
