Microsoft Access... help!

[cerah]

Ok so this isn't exactly the usual "Heart-to-Heart" topic but I figured it was the best place to put it.

I'm trying to make this big stupid database for the company I work for. All the data n the main form works perfectly. Now I'm trying to make a form (maybe it should be a report I dunno) that changes with data you input but doesn't update the master table with said new data.

Basically what it is is a big packaging database. We package some tools/products and you need to know how many labels n surlyn (plastic stuff) and cards n shit you need to package it with. I need to be able to input a packaging quantity (that's constantly changing) and have it be multiplied by all the other quantities on the page.

I.E.

I wanna package 10 heavy duty filter wrenches... so I use a drop down search box to pull up the product number and enter 10 into the packaging quantity box. It then has to multiply each label by 10 (or 5 or 8 or 45 or whatever I put in the packaging quantity box).

I know there has to be some retardly easy way to do this but I can't figure it out (yes fine I'm a dumbass... I really don't care right now). I've looked online and asked smug lil Clipit (god how I hate him) and I can't figure it out... so ya... help!

[Gusto]

okay, it's been a while since i've touched vb... my syntax might be a little rusty. i'm assuming that all the data is pulled from the db and you just want to update each packaging type quantity to reflect how many units are getting sent. are the packaging types the same for each or do they get pulled from an array or something? anyway, something like this?

private sub submit_Click(quantity)

lbl_pkgtypeqnty1.value = (lbl_pkgtypeqnty1.value*quantity)
lbl_pkgtypeqnty2.value = (lbl_pkgtypeqnty2.value*quantity)
lbl_pkgtypeqnty3.value = (lbl_pkgtypeqnty3.value*quantity)

end sub

[Gusto]

seems like you know what you're doing though, and what i posted was pretty basic. maybe i'm missing something, or maybe you just overlooked it. it happens.

[cerah]

Ya I don't really know Access very much at all... the last time I used it was 5 years ago so ummm basically you just confused me more I think. But thanks for trying!

Like it seems so easy in my head what I want it to do I just don't know how to tell the machine to do it and fuck is it frustrating!