How to delete a record

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a database with three tables as follows
Table 1=Documents
Table 2= Groups
On a form based on Table 1 is a continuous subfrom that has a combo box
based on Table 2
When the user makes a selection in the combo box the selection is saved in a
third table Table 3
The user can make any number of selections of the combo box hence the reason
for a continuous form
If the user later deletes the value of a combo box for any record in Table 1
then the control stays empty and I end up with a blank record in Table 3.

What I want to do is if the user deletes a value in the combo box I want to
delete that record in Table 3

I hope that's explained what I am trying to do BUT how do I do it?

TIA
Tony Williams
 
I have a database with three tables as follows
Table 1=Documents
Table 2= Groups
On a form based on Table 1 is a continuous subfrom that has a combo box
based on Table 2
When the user makes a selection in the combo box the selection is saved in a
third table Table 3
The user can make any number of selections of the combo box hence the reason
for a continuous form
If the user later deletes the value of a combo box for any record in Table 1
then the control stays empty and I end up with a blank record in Table 3.

What I want to do is if the user deletes a value in the combo box I want to
delete that record in Table 3

I hope that's explained what I am trying to do BUT how do I do it?
Click to expand...

I'm afraid I'm still confused. You CANNOT "store data in a combo box"
or "delete the value of a combo box"; a combo box is just a tool which
displays data in a Table. It sounds like you're storing data
redundantly in Table2 and also in Table3, and that you want to delete
a record in Table3 (under circumstances which I cannot quite
understand).

What are the Recordsources of the form and the subform? What is the
RowSource of the comb box? What are you deleting?
 
Back
Top