help!!- deleting information from a table when selected in a combobox

[Hanny J]

I am making a database for a dress shop, which hires and sells prom
dresses. I am creating a form where the user selects the customer
using a list box and then using a combo box to select a dress. The
combo box is connected to a query which looks in the dress information
table and the dresses which status is for sale will then be shown
inboth the query and the combo box.

The Problem I am having is that, when the dress is selected on the
form and is saved to a sales table, I want the orginal dress
information for that selected dress to be deleted in the dress
information table. Does anyone know how i can do this?

Hope that makes sense

Thank you

[Don Calloway]

On Sun, 30 Dec 2007 04:09:58 -0800, Hanny J wrote:

I am making a database for a dress shop, which hires and sells prom
dresses. I am creating a form where the user selects the customer using
a list box and then using a combo box to select a dress. The combo box
is connected to a query which looks in the dress information table and
the dresses which status is for sale will then be shown inboth the query
and the combo box.

The Problem I am having is that, when the dress is selected on the form
and is saved to a sales table, I want the orginal dress information for
that selected dress to be deleted in the dress information table. Does
anyone know how i can do this?

Hope that makes sense

Thank you

I'm not sure why you would want to delete the dress information in the
dress table; wouldn't you rather mark the item as unavailable, or
something like that? Anyway, to do what you want you would need to
create VB code in the dress combo box's AfterUpdate event which deletes
the corresponding record in the dress table. Hope this helps.

[Hanny J]

On Dec 30 2007, 2:46�pm, Don Calloway <[e-mail]:

On Sun, 30 Dec 2007 04:09:58 -0800, Hanny J wrote:

I am making a database for a dress shop, which hires and sells prom
dresses. I am creating a form where the user selects the customer using
a list box and then using a combo box to select a dress. The combo box
is connected to a query which looks in the dress information table and
the dresses which status is for sale will then be shown inboth the query
and the combo box.

The Problem I am having is that, when the dress is selected on the form
and is saved to a sales table, I want the orginal dress information for
that selected dress to be deleted in the dress information table. Does
anyone know how i can do this?

Hope that makes sense

Thank you

I'm not sure why you would want to delete the dress information in the
dress table; wouldn't you rather mark the item as unavailable, or
something like that? �Anyway, to do what you want you would need to
create VB code in the dress combo box's AfterUpdate event which deletes
the corresponding record in the dress table. �Hope this helps.- Hide quoted text -

- Show quoted text -

thanks I will try VB coding, and ordinally I had the idea of showing
the dress as unavailable, so will try that if I can't do the coding

Thank you for your help