How do I create my own Order form?? 1

[Minadude]

Hello all! It's my first posting and I've been looking to get an answer to this problem for quite sime time.

I have a database with MS Access 2003 that contains an inventory items table, a customer table, with all the forms and subforms....my only problem is that when I select on the order form the productID from my combo box, the field next to it (product description) does not show automatically according to the chosen productID...

I also need the price to be linked with the previous 2 fields...any ideas?

Thank you very very much in advance!!

 

[ZmrAbdulla]

1) Create a new form through the wizard using the table as recordsource.

2) place a combobox and follow the wizard choosing the third option. Remember to choose StockNumber field.

3) place another combobox and follow the wizard choosing the third option and choose porduct description field this time.

see what happens when search for stock number or description?

________________________________________________________
Zameer Abdulla
Help to find Missing people
All cats love fish but fear to wet their paws..

 

[Minadude]

Nice hearing again from you Zameer!

I'll try it right now.

don't go away!

Mina

 

[Minadude]

when I chose a stockNumber from the cbBox, it populates all the fields EXCEPT the Description.

and vice-versa for the Description....

weird...any ideas?

Thanks

Mina

 

[ZmrAbdulla]

here is a sample..

http://www.geocities.com/zameerabd/dl/sample.zip(30kb)

________________________________________________________
Zameer Abdulla
Help to find Missing people
All cats love fish but fear to wet their paws..

 

[Minadude]

nice sample...this is the closest thing to what I'm trying to do here...I was actually trying to populate the combo boxes themselves...I guess it's simplier this way...just esthetically less effiecient on an order form....

is it possible to have those 2 combo boxes to search the products table on a seperate form? like a "pop-up" window called "search"....then those 2 combo boxes will pop....then the user searches either by stock or description then whatever he chose last he hits "Enter" and it populates the field on the OTHER form...

let me know what you think.

Thanks

Mina

 

[ZmrAbdulla]

Why do you need a separate form? If the form intented to print as an invoice then I will say create a report for printing.

________________________________________________________
Zameer Abdulla
Help to find Missing people
All cats love fish but fear to wet their paws..

 

[Minadude]

You're right...I'll play with what I have now for a couple of days and I'll let you know!

Thanks for all your help!

Mina