no records show in synch combo box

[sk1hotpepr]

I have two combo boxes to filter records - upgraded to access project (adp) with sql server backend. everything works fine as the database owner, but if I try to do the same thing on a user station with connectivity only - i don't get any records with the filter. does anyone know why? i'm just learning as i go...

the first combo box has a value list of the alphabet
the second combo box uses an inline function as it's rowsource.

Private Sub cmbLetter_AfterUpdate() 'first combo box
    Me.cmbLookup.Requery
    Me.cmbLookup.SetFocus
End Sub

Private Sub cmbLookup_Change()      'second combo box
    Dim stLink As String
    Dim stDocName As String
    
    stDocName = "ProjectInformationFormMain"
    
    Me.cmbLookup.SetFocus
    stLink = Me.cmbLookup.Text
    
    DoCmd.OpenForm stDocName, acNormal
    Forms![ProjectInformationFormMain]!ProjectNumber.SetFocus
    DoCmd.FindRecord stLink
    
    DoCmd.Close acForm, "FormLookup"
End Sub

Private Sub cmbLookup_GotFocus()    'second combo box
    If IsNull(cmbLetter) Then
    MsgBox "Please Choose A Letter"
    Me.cmbLetter.SetFocus
    End If
End Sub

 

[jgoodman00]

Have the standard users been granted the appropriate privileges to the tables/functions etc as applicable?

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[sk1hotpepr]

James,
Thank you for taking the time to look this over for me.

I'm not sure - right now they have standard user privileges w/ db_dataread and db_datawrite access. Do I need to give privileges specifically to the table and functions as well?

 

[jgoodman00]

Yes, you will probably need to give them explicit permission on the functions.

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[sk1hotpepr]

I gave them SELECT,INSERT, UPDATE and DELETE permissions on the Function, and I gave them SELECT,INSERT, UPDATE permissions on the table that references the stored procedure - its still not working. What am I missing??

Do I need to add the user into the Master database? I'm using the Enterprise Manager to make all of these changes...

 

[sk1hotpepr]

James -
Searching through some other posts, I came to realize one minor omission - I didn't have dbo in front of the function name. The other post alerted me that unless you are the database owner, you need that!

Thank you for your help!