How to delete multiple records on a form?

[busterbaxter]

Hi All,

I have an existing inventory database that I'm trying to make changes to. The database only has 1 table with the following fields:

PartNumber
ItemDescription
Category
Location
Owner
SerialNumber.

Currently I'm using the delete button to delete a single item. However this is not really efficient if I have to delete 300 disk drives. I do have the add multiple copies working thanks to Bytes! So, I'd like to do the same thing for the delete but with a twist.

I created a seperate command on my form called 'cmdDeleteMulti ple' and an unbound text box called 'NumberDeleted' . (I only did this in Design View). However I would like for the 'cmdDeleteMulti ple' and 'NumberDeleted' to be greyed out or hidden when the 'SerialNumber' field is populated. The 'SerialNumber' field has text as the Data Type.

Is this possible?


Thanks,

Kevin

[busterbaxter]

More questions about this....

How will the delete command know what to delete when it has to delete multiple copies? The copy command selects the record and just creates a duplicate but the delete is much different because it will have to know which record to delete.

Thanks,

Kevin