G
Guest
Vista Ultimate / Office 2007 Pro
Great to have the split form funtionality in Access...but...I've have two
issues I hope someone can give advice on....please...
Firstly,
I use a split form; datasheet to show all records, and the main form to show
full details of the record selected in the datasheet. The form has a sub-form
showing associated records from another table. I have a button to delete the
current record, which also runs a query to delete the sub-forms associated
records from the other table. However, if the selected record in the split
form datasheet is deleted by pressing Del it will delete the current record,
but of course does not run the query to delete associated records. Setting
the forms 'allow deletions' property to No simply prevents me from deleting
the record at all, even from clicking my delete button on the main form. How
can I prevent deletion via the datasheet, thus forcing to use the delete
button on my form (thus deleting all relevant records via my delete query)??
Secondly, and it's also to do with the split form...
Keeping with my example above of a split form; datasheet and main form to
show the selected record in the datasheet... A label caption (and other
controls) on the main form changes according to the 'status' (field) of a
record. However, changing selection in the datasheet does not repaint the
main form to change the label to the records 'status'. It simply changes the
current record displayed. How can I fire an event to repaint (or requery?)
the main form to correctly show the label caption according to the records
'status'?? The 'on selection change' property doesn't seem to do anything...
I'd really appreciate some help on the above.
Cheers,
John
Great to have the split form funtionality in Access...but...I've have two
issues I hope someone can give advice on....please...
Firstly,
I use a split form; datasheet to show all records, and the main form to show
full details of the record selected in the datasheet. The form has a sub-form
showing associated records from another table. I have a button to delete the
current record, which also runs a query to delete the sub-forms associated
records from the other table. However, if the selected record in the split
form datasheet is deleted by pressing Del it will delete the current record,
but of course does not run the query to delete associated records. Setting
the forms 'allow deletions' property to No simply prevents me from deleting
the record at all, even from clicking my delete button on the main form. How
can I prevent deletion via the datasheet, thus forcing to use the delete
button on my form (thus deleting all relevant records via my delete query)??
Secondly, and it's also to do with the split form...
Keeping with my example above of a split form; datasheet and main form to
show the selected record in the datasheet... A label caption (and other
controls) on the main form changes according to the 'status' (field) of a
record. However, changing selection in the datasheet does not repaint the
main form to change the label to the records 'status'. It simply changes the
current record displayed. How can I fire an event to repaint (or requery?)
the main form to correctly show the label caption according to the records
'status'?? The 'on selection change' property doesn't seem to do anything...
I'd really appreciate some help on the above.
Cheers,
John