invoice program

[cpreece]

I'm doing a simple invoicing program and am getting very aggravated.
I have 4 tables:

Customers
CustID,Name,Address,City,State,Zip

Items
ItemID,ItemName, Description, UnitPrice

Orders
OrderID,CustID,OrderDate,ShipDate,ShipFee

Item Line Items
OrderID,ItemID, Description, UnitPrice

Here are the problems I am having:
On the main order form I want to list all of the info from the order
table and use a combo box to list customers. How do I populate th
customer address after I select their name form the combo box?

Then I want to add a subform based on the Item Line Items table.
When I create a combo box for the ItemID, the description and uni
price are supposed to fill in but this is not happening.

I'm sure that once I get past this hump I will be fine.

Please help..

 

[PC Datasheet]

<<populate the customer address after I select their name form the combo box?>>

Put the following code in the AfterUpdate event of the combobox:
Me!NameOfAddressTextbox = Me!NameOfComboBox(2)
Me!NameOfCityTextbox = Me!NameOfComboBox(3)
Me!NameOfStateTextbox = Me!NameOfComboBox(4)
Me!NameOfZipTextbox = Me!NameOfComboBox(5)

Note: your combobox must be set up for 6 columns!

<<description and unit price are supposed to fill in but this is not
happening.>>

Same principle!!

 

[Terry]

PC-
I'm trying your suggestion below, but receive an error.
Run-time error '451' - "Property let porcedure not defined
and property get procedure did not return an object". This
looks simple, and if I understand correctly, you are just
using the 'index' of the combo box to return the value of
that column, right? So why the error?
Thanks.

Terry

 

[Terry]

Found the issue.
Should be:

Me!NameOfCityTextbox = Me!NameOfComboBox.column(2)

Thanks www.mvps.org

Terry