Form wont let me update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the following code to open my form. No adds 'take', does anyone know why, do I have to specify acFormAdd instead of acFormEdit? My form does have allowedits, allowadds and allowdeletes set

Dim strSQL As String
strSQL = "SELECT * FROM tblSupportGroups" & _
" WHERE SupportGroup IN" & _
" (SELECT SupportGroup FROM tblSupportAreaGroups " & _
SQLSA(, , "All") & ") ORDER BY Description;"
DoCmd.OpenForm "frmUpdSuppGrps", acNormal, , , acFormEdit, acWindowNormal, strSQL
 
Is there some referential integrity that the record
addition is violating?
I couldn't replicate the problem using a similiar
example, so I don't think the OpenForm command is the
issue in itself. I also assume that you are setting the
form's recordsource property in the Open event
i.e.
me.Recordsource=me.OpenArgs
-----Original Message-----
I am using the following code to open my form. No
Click to expand...
adds 'take', does anyone know why, do I have to specify
acFormAdd instead of acFormEdit? My form does have
allowedits, allowadds and allowdeletes set
Dim strSQL As String
strSQL = "SELECT * FROM tblSupportGroups" & _
" WHERE SupportGroup IN" & _
" (SELECT SupportGroup FROM tblSupportAreaGroups " & _
SQLSA(, , "All") & ") ORDER BY Description;"
DoCmd.OpenForm "frmUpdSuppGrps", acNormal, , ,
Click to expand...
acFormEdit, acWindowNormal, strSQL
 
Back
Top