Delete Record

[Dave Hawks]

I want to delete a record in fldPlayer in frmTable1 based on an If Then
Statement in a second form frm Authenticate.
Can anyone suggest some suitable code.

Thanks

 

[Michel Walsh]

DoCmd.RunSQL "DELETE * FROM tableNameHere WHERE
flfPlayer=FORMS!frmTable1!fldPlayer "




should do.


Hoping it may help,
Vanderghast, Access MVP

 

[Dave Hawks]

Mike
Thanks for your help.
--
Dave Hawks

DoCmd.RunSQL "DELETE * FROM tableNameHere WHERE
flfPlayer=FORMS!frmTable1!fldPlayer "




should do.


Hoping it may help,
Vanderghast, Access MVP