Delete button

[bigfoot53]

I have created a new form to delete records from a table via several combo boxes . the forms work except that when i click delete it removes the 1st file from the table not the file in the form that i want to remove . how do i make it work ?

I have attached the file for example.
thanks

 

[Rob.Mills]

I'm not able to look at your file at work due to the fact that I can't open zip files. But let me ask you this. Are you using a delete query whose criteria references these combo boxes?

 

[bigfoot53]

i made the button with the wizard.

 

[Rob.Mills]

I'm assuming you're using the comboboxes to limit the records that are deleted, yes?

If so, setup a delete query where the criteria of the fields reference those combo boxes.

Then setup the button to open the query.

 

[bigfoot53]

I use the combo boxes to drill down to a specific record . all the data matches what is in the master table . when i click the delete button it delets the first record from the master table not the record that i selected in my new form .

 

[ghudson]

Maybe you need to select the record that you want to delete?

DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord

HTH