Update from a form based on a one to many relationship

  • Thread starter Thread starter Stanley
  • Start date Start date
S

Stanley

I have a form bound to a stored procedure with a 1-many
relationship. I understand that this form is not
updateable since the stored procedure has a parameter. The
many side has a check box, where I would click a check box
in particular rows, and update the fields bould to these
check boxes in SQL Server.

I was thinking about making the source of the form a
recordset. I understand this would be a local cache. When
I am finished updating the form, I can then update the
backend. Does this seem viable. Any ideas, since this
seems to be commom problem.
Thanks,
Stan
 
Your form can be updateable even if the underlying stored procedure has a
parameter. Your problem with the form being read only is probably coming
from another source.

For example, make sure that each of the records and tables have a primary
key; set the Unique Table property of the form (do it inside the OnOpen
event of the form if necessary if you cannot do it from the GUI); add a
Resync Command (may be a dummy one); make a liberal use of the Refresh
option from the View menu when viewing the list of queries; force a full
recompilation of all modules by adding a unused reference in the VBA window
(and remove it the next time you want a full recompilation); etc., etc.

The use of a specialised table for storing temporary results on the server
can also be handy on some occasions.

As suggestion in you question, you can also bind your forms to your own
recordsets. See for example:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;281998

The bad new is that ADPs are full of such surprises (read bugs). This is
why you may have see this as a common problem.

S. L.
 
Back
Top