S
sbrand
I am using the ADP component of Access 2003 and SQL server database.
In a subform I display a record set. When modifications are made to a
record the record is saved to the SQL table after the end of the
session. I have a problem in that I don't want anyone to modify a
subform record that is approved. Is there some way I can create a
variable on the record set that indicates a specific subform record is
approved, and then not allow the cursor to enter the other fields on
the record that record. It would be a round about way of locking the
record. I know this is possible if the subform records are directly
connected to an Access table, but I have not been successful with a
record set. Any other suggestions are welcomed.
In a subform I display a record set. When modifications are made to a
record the record is saved to the SQL table after the end of the
session. I have a problem in that I don't want anyone to modify a
subform record that is approved. Is there some way I can create a
variable on the record set that indicates a specific subform record is
approved, and then not allow the cursor to enter the other fields on
the record that record. It would be a round about way of locking the
record. I know this is possible if the subform records are directly
connected to an Access table, but I have not been successful with a
record set. Any other suggestions are welcomed.