Poputalte fields from drop down.....

[CEH]

OK.... This sounds like it should be simple..... But I might not be searching in the correct place.... I am very new to Access.... But I am trying to make a form, more or less an Invoice order form......Containing Customer information ...service location... Then products purchased........ What I am having trouble with now is a dropdown box and what I want it to do......
The dropdown will be on "Customer#" When you choose a Customer # I want the address fields to fill in. Same with picking a "Service location" Both Customer info and Service location info are loaded in seperate tables.........
Can't seem to find out how to tell it to load these fields when I pick the ID number from a dropdown.......

Thanks

 

[trucktime]

Sample File

CEH,

Here's a sample mdb that I picked up from a forum. It demonstrates how to autopopulate fields from a dropdown box, based on a different table. Don't forget to adjust the field/tablenames. Good luck. Trucktime

 

[Milothicus]

you need an ID autonumber field (easiest) in each of the subordinate tables (customers, etc.)

then in your invoice table, you need a field to associate each invoice with a customer.

make a combo. it's rowsource should include both the ID column and whatever field you want to display to choose from.
the bound column should be 1, column count should be 2, column widths should be 0";1", and the control source should be the field in the invoice table.