[MS_AccessPros] Deleting a record from a button

 

I have a table call tblUnitTenant with the following fields:

UnitID
PeopleID

I have two forms:

frmUnitDetail
UnitID
UnitStatus
cmdRemoveTenant

sfrmTenant

The sfrmTenant contians the tblUnitTenant fields and is linked to the frmUnitDetail via unitid.

If the use changed the UnitStatus to Vacant I need the record in the tblUnitTenant (sfrmTenant) deleted or if they press the cmdRemoveTenant button the same thing needs to happen.

Is this possible?

Thanks,

Art Lorenzini
Sioux Falls, SD

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 13
• New Links 2
• New Files 10

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___