I think all you where missing from the original code was a ?
when you specify the recordsource for the stored procs with parameters, u need to replace the parameters bit with ?
so for example
your code:
Me.subfrmdata.Form.RecordSource = "EXEC dbo.getinv"
Me.subfrmdata.Form.InputParameters =...
There could be several reasons why.
Primarily you will want to check out the 'Unique Table' property of the form.
other things to check are the usual 'allow additions', edits,deletions properties toooo
;-)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.