using cascading combo box to select and then delete records

[jaymin]

Hi all,
I have a database that allocates portfolios to staff, so i have three tables 1,Staff 2,Portfolio 3,Allocated Portfolio, what i want to do is to be able to delete the allocation by using two cascading combo boxs, the first combo selects the staff, the second the portfolio that is accociated to that staff member. i can get the combo to cascade with the right data but i cannot get it to then delete the selected record from the table.
hope someone can put me on the right track.


Peter

[June7]

Deleting records should be a rare occurrence. Why do you want to delete? Why can't you do that? What have you tried? Post code. What happens - error message, wrong result, nothing?

Something like:

CurrentDb.Execute "DELETE FROM tblPortfolioAllocation WHERE IDPortfolioAllocation = " & Me.comboboxname

[Demerit]

Currentdb.Execute "DELETE * FROM tblPortfolioAllocation WHERE IDPortfolioAllocation =" & Me.ComboName
CurrentDb.Execute "DELETE * FROM tblStaff WHERE StaffID =" & Me.ComboName

[jaymin]

Currentdb.Execute "DELETE * FROM tblPortfolioAllocation WHERE IDPortfolioAllocation =" & Me.ComboName
CurrentDb.Execute "DELETE * FROM tblStaff WHERE StaffID =" & Me.ComboName

Hi Guys,
Thank you for your quick reply, got what I wanted to work with your help many thanks, must have had a bit of a seniors moment.
had formatting wrong.
Peter