Avoid delete

[krishnanhemanth]

Hi
In my database, there are
"PURCHASE ORDER" form -------"PURCHASE ORDER" table--"PONO"--PK
"MATERIAL RECEIPT" form------"MATERIAL RECEIPT" TABLE-"PONO"--FK

the material recieved is entered in the "MATERIAL RECEIPT"form wrt the "PONO"
I DONTWANT THE USER TO USE THE DELETE BUTTON AVAILABLE ON THE PURCHASE ORDER FORM IF A MATERIAL IS RECIEVED IN THE MATERIAL RECEIPT FORM ON THAT PARTICULAR PONO

FROM THE purchase order form if i can look up the MATERIAL RECEIPT table and check the pono selected, then the DELETE BUTTON can be disabled.
how do i do this
please help

 

[ShaneMan]

Hi
In my database, there are
"PURCHASE ORDER" form -------"PURCHASE ORDER" table--"PONO"--PK
"MATERIAL RECEIPT" form------"MATERIAL RECEIPT" TABLE-"PONO"--FK

the material recieved is entered in the "MATERIAL RECEIPT"form wrt the "PONO"
I DONTWANT THE USER TO USE THE DELETE BUTTON AVAILABLE ON THE PURCHASE ORDER FORM IF A MATERIAL IS RECIEVED IN THE MATERIAL RECEIPT FORM ON THAT PARTICULAR PONO

FROM THE purchase order form if i can look up the MATERIAL RECEIPT table and check the pono selected, then the DELETE BUTTON can be disabled.
how do i do this
please help

You could do a DCount, matching the criteria you need, when the Purchase Order form opens and if it equals 0 then all the Delete cmdButton to be enabled otherwise it's not.

Just a thought!

HTH,
Shane

 

[krishnanhemanth]

thanks for the reply

i solved it by using the dlookup function