ComboBox Help BAD!!!!!!!PLEASE

[DaniBoy]

Hello,

I have an invoice form with its detail subform that I have been stuck with for a while. The main problem is on the detail subform, here is what I have:

1. I have 5 fields, DepartmentID, ProductID, Qty, Price, Total.

2. The department is a combobox and I want to select the department that the product is from. Example: If I will be selling a pvc pipe I should select PVC Department.

3. Once I select the department I want the product combobox to only show the products from that department. So I select Electrical Department I can only see what items belong to the Electrical Department.

That is basicaly what I need it to do. So, I worked hard on this looked at samples, read threathds, pull all my hair out, almost done eating all my nails, and most of you know how that goes!!!!

Well finaly after sleepless nights I got something to work!!! I was able to make the product combobox only show the items from that department, Man I was jumping of joy!!! I turnon my radio and put on "Eye of the tiger" and started boxing away!!!! jejeje

Well, I started to make it look pretty, changing the looks and changing the comboboxes to show me the name of the department not the ID, worked good, than I changed the product combobox to show the name not the ID and something went wrong......

The department combobox does a requery of the product combobox everytime I select the department for a new item. So for some reason it makes the product code from the other item disapear....I cant figure it out!!

I have attached the DB, goto frmFactura there is already one invoice started, I have selected the PVC Dept and the Product, you can also see the prtoduct code, once you goto the next item and select another department the prodcode desapears but the prodid stays...


CAN YOU HELP ME PLEASE!!!!!

 

[Rickster57]

subform

Are you sure your subform wasn't originally a single form? I see now where the subform you are using is a continuous form.

 

[DaniBoy]

Yes its always been a continues form, I am actualy building the db. If I didnt had to choose the department and only pick the product I wouldnt have any problems, but the client uses the same product code for different departments, example:

Department Plumming
10" galvanize tube Product Code is 1578

Department Electrical

Wall Outlet Product code is 1578

Basicaly the same product code, but since they do all by hand they just put what department that belongs to....

So this makes it difficult, there would be lots of user errors during the invoicing....

Thats why I want the user to select the depertment of the product its going to invoice and have the only the products from that department show on the product list.

Am not sure if I am explaining myself clear, do you understand what I am trying to do?


thansk for the help

 

[llkhoutx]

I'd answer if you had a succinct question.

I'm too lazy to drill down, download, unzip, or do pushups.