supress a record on MS Access Form

  • Thread starter Thread starter FA
  • Start date Start date
F

FA

Hi, I have this problem that i have not been able to resolve. I have a
form based on table STD_FINDG. There is field called FINDG_NME and in
this field user wants to delete one record but they can not delete any
record since table STD_FINDG has a chile table FINDG. So i thought
there should be a vba code where they can supress the record instead of
deleting the record on the form. So i decided to have a check box on
the form which will allow them to supress any record they want from
STD_FINDG table. I do not know how to start writing code for that.

If anybody has any idea about that please let me know.

Thanks

Moe
 
I tried to set the relationship properties "Cascade Delete Related
Record" but its deleting the child record too. User do not want to
delete the chile record, they just want to delte the parent record. Any
suggestions??

thanks
 
Hi, I have this problem that i have not been able to resolve. I have a
form based on table STD_FINDG. There is field called FINDG_NME and in
this field user wants to delete one record but they can not delete any
record since table STD_FINDG has a chile table FINDG. So i thought
there should be a vba code where they can supress the record instead of
deleting the record on the form. So i decided to have a check box on
the form which will allow them to supress any record they want from
STD_FINDG table. I do not know how to start writing code for that.
Click to expand...

You don't need any "code".

Just base the Form on a Query selecting records which aren't
suppressed - e.g. if your Yes/No field is set to
"True"/"Yes"/checked/-1 for records that you want to suppress, use a
criterion of False on your query.

John W. Vinson[MVP]
 
Back
Top