Order Entry Template Problem

[Nasir Khan]

Hello All,

I tried to search this problem in the newsgroup but failed (due to my very
limited knowledge).

I have used the template of Access 2002 and created the Order Entry
database.

I changed the CompanyName text box to a combo box on the "Orders by
Customer" form and set its RowSource to show the company names in Ascending
order and it works fine. My problem is that if I select any company from
the combo box.. the related records.. for eg. CustomerID, FirstName,
LastName, Billing Address.etc etc ..... in other words all the other field
does not change to reflect the record selected for the CompanyName selected
in the Combo Box!
How can I achieve this ?
I hope I have made myself clear.

Also I tried to get the "combobox wizard" started but did not succeed.. Is
it required to be installed as an Add In? How can I see the combobox wizard
to work on a form??

I would appreaciate any help in this matter.

TIA

Nasir

 

[JulieD]

Hi Nasir

basically forms are used for adding / editing and viewing information - what
you are trying to do is make the form a filter on the company name combo
box... if you notice down the bottom of the form are some buttons for
stepping through the different records.

in my opinion, the easiest way to achieve what you want is to
create another form - a "Select Company" Form
Forms Area
Create form in design view
use the Combo Box wizard to put 1 combo box on the form which
displays all the companies
use the Command button wizard to put 2 command buttons on the form
Ok button - which opens the Orders by Customer form and displays
the information relating to the selected customer
Cancel button which closes the form

Now, when you want to see the information for a selected company, you choose
it in the Select Company form and click the Ok button and the Order form
will open up.

there is another way - where you embed the Orders by Company form as a sub
form into another form where you choose the company ... but that's a bit
more complex than the method outlined above. However, if you'ld like
information on how to achieve what you want using this method, please post
back.

Regarding the wizard - apart from ensuring that the Control Wizards icon on
the toolbox is selected i have no ideas - sorry.

Let us know how you get on
Cheers
JulieD