SQL to return updateable records

[C8H10N4O2]

I am using an SQL statement in a forms record source. This statement distinguishes between departments and returns all the records for that department. The problem is the forms main intention is to allow users to enter new records into the database. This worked before I used the SQL statement simply by the user pressing the >* button, but this button is now not pressable.

Here is my SQL statement

[code]... SELECT * FROM Supervisor, UserInfo WHERE (((UserInfo.DeptID)=+2)) And Supervisor.ID=UserInfo.ID..[code]

I have tried an insert statement but cannot seem to get this to work...Any help would be appreciated. Thanks

[C8H10N4O2]

Oh yeah here is the vb code for this app

....Const ReplString = "+2"
    Dim intInsPt As Integer, strUserMatch As Variant
 
    intInsPt = InStr(Me.RecordSource, ReplString)
    If intInsPt = 0 Then
        ' Oops! SQL template has no ReplString in it!
        Beep
        MsgBox "Form Record Source error. Notify programmer.", vbExclamation
        Cancel = True
        Exit Sub
    End If
    strUserMatch = DLookup("UserInfo.DeptID", _
        "UserInfo", "UserName='" & CurrentUser() & "'")
 
    If IsNull(strUserMatch) Then
        ' Oops! No match for user in UserInfo table
        Beep
        MsgBox "No permission found for " & CurrentUser() _
            & ". Notify programmer.", vbExclamation
        Cancel = True
        Exit Sub
    End If
    ' Now modify the form record source to select
    ' records for this user only
    Me.RecordSource = Left$(Me.RecordSource, intInsPt - 1) _
        & strUserMatch _
        & Mid$(Me.RecordSource, intInsPt + Len(ReplString))
 
 

[MMcCarthy]

Your form is probably based on a query which is not updateable. I would suggest that you create a new form with the purpose of entering data only. You can have it open on a button click event on this form. Tie it to the table or query it used to be tied to. Make sure the forms data entry property is set to yes.

I am using an SQL statement in a forms record source. This statement distinguishes between departments and returns all the records for that department. The problem is the forms main intention is to allow users to enter new records into the database. This worked before I used the SQL statement simply by the user pressing the >* button, but this button is now not pressable.

Here is my SQL statement

[code]... SELECT * FROM Supervisor, UserInfo WHERE (((UserInfo.DeptID)=+2)) And Supervisor.ID=UserInfo.ID..[code]

I have tried an insert statement but cannot seem to get this to work...Any help would be appreciated. Thanks

[C8H10N4O2]

I was thinking that too...I still would not like for the dept to see each others data though and that would be the case with this.... Right? or is there a way to not have any records shown only a blank form that you can input into?

[MMcCarthy]

Changing the Data Entry option to Yes will only show a new record. No other records will be visible.

I was thinking that too...I still would not like for the dept to see each others data though and that would be the case with this.... Right? or is there a way to not have any records shown only a blank form that you can input into?

[C8H10N4O2]

Thanks, I'm heading in a whole different direction now