Michael,
the tblUnitTenant table is a link table between my tblUnit and tblPeople tables. Without deleting the entry how would I remove the entry so the subform for the tenant ahows that it is blank? I have a tenant module which I am working on so would I flag it there? The idea is the user should be able to remove the tenant entry from within the unit details form if the unit becomes vacant.
With warm regards,
Arthur Lorenzini
Sioux Falls, South Dakota
________________________________
From: michael simpson <saccity101@yahoo.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, January 31, 2012 9:28 AM
Subject: Re: [MS_AccessPros] Deleting a record from a button
Art -
Why are you deleting a record,
I would hope that you are saving the information somewhere.
I have move in date, move out date, initial rent, current rent,
and a field Active that I toggle to filter out past tenants
Take care, Michael
From: Art <dbalorenzini@yahoo.com>
>To: MS_Access_Professionals@yahoogroups.com
>Sent: Tuesday, January 31, 2012 6:18 AM
>Subject: [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
>
>
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar