Using Access with SQl Server system stored procedures

[jcfrasco]

I've created a stored procedure using a SELECT statement and I used the @user to get the current user. I'm using the stored procedure as the control source for a form and I want to lock certain fields based on who the user is. I set a text box control source equal to the user and now I want to use VBA to program my form with If...Else statements. I can make a MsgBox indicate the user, but no matter what I try I can't get an If statement, (exp: If Me!User.value = "sdial" Then), to equal the condition. And I know that it is "sdial"! What seems to be my error and are there any better ways at doing this?

 

[tlbroadbent]

When do you perform the If... Then... Else test - in a form event such as Form Load, when clicking a button, ...? Terry

;-) He has the right to criticize who has the heart to help. -Abraham Lincoln

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[jcfrasco]

Terry,

I plan on using it during form Open. Once the form opens and the fields are locked or unlocked, they won't need to change. If you need any additional information I'll respond as soon as I receive the e-mail notification.

Thank you,
jcfrasco

 

[tlbroadbent]

I'm trying to duplicate the problem but can't seem to do so. The If... Then... Else works well. I've tried it in Form Open, Activate, and On Current events without error.

Could you be so kind as to post the code, including the Stored Proc?

Thanks, Terry

;-) He has the right to criticize who has the heart to help. -Abraham Lincoln

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm