B
Birderman
HI,
Any help would be appreciated.
Using Access 2003
question 1
I have a form for entering data.
wih one object on the form (yes/no field) I want to inititiate vba code to
run if it changes.
I have no problem gettting it to update the table and append data (runs
macro which opens several queries)linked to it but if the field is changed
to 'NO'
I want it to find and delete an associated record in a different table
(within the same database). The vba code samples I have found on the
interenet do not appear to work correctly. Can someone please point me in
the right direction and possibly provide sample code for findind and
deleting records according to change in particular field on a form for a
different table.
question 2
I Have a form with several buttons to drive different events that work.
I want the buttons to be enabled or disabled dependent upon certain entries
within fields on the form.
After Update event I can achive this - but it means I need to move to the
next record and back again to the original record to see any change.
If I use requery to update the from to display the buttons in the revised
enabled/disabled state the form moves to the beginning of the recordset, is
there a way to refresh the form without changing records so that if a field
is updated the buttons are displayed correctly.
TIA
Birderman
(e-mail address removed)
Any help would be appreciated.
Using Access 2003
question 1
I have a form for entering data.
wih one object on the form (yes/no field) I want to inititiate vba code to
run if it changes.
I have no problem gettting it to update the table and append data (runs
macro which opens several queries)linked to it but if the field is changed
to 'NO'
I want it to find and delete an associated record in a different table
(within the same database). The vba code samples I have found on the
interenet do not appear to work correctly. Can someone please point me in
the right direction and possibly provide sample code for findind and
deleting records according to change in particular field on a form for a
different table.
question 2
I Have a form with several buttons to drive different events that work.
I want the buttons to be enabled or disabled dependent upon certain entries
within fields on the form.
After Update event I can achive this - but it means I need to move to the
next record and back again to the original record to see any change.
If I use requery to update the from to display the buttons in the revised
enabled/disabled state the form moves to the beginning of the recordset, is
there a way to refresh the form without changing records so that if a field
is updated the buttons are displayed correctly.
TIA
Birderman
(e-mail address removed)