Combox Box Help

[BLD21]

access 2007,

I have a form that is using a table for it's source. In my table I have field names of Company, Cust Name, Addr1, CSZ.

In my form I am using a combox to select the company names.



What I would like to do is when a company name is selected from the combox box on the form the other fields(cust name, addr1, csz) are then populated based on that company name.

I am lost on how this could be done.

Thanks to everyone!
Bruce D.

[pbaldy]

Try this:

BaldyWeb - Autofill

[BLD21]

P:

I need my form to populate a table named "tbl_invoice. 5 of the 6 fields in my form are using another table named "acct names". This is for my combo box using "company name" and then based on the company name populating the other address fields. This works fine but the data is not being saved in the other table "tbl_invoice".

In my first text box I have set for the control source = [tbl_invoice]![addr1] of where I want the addr stored. But for the after update event of the combo box why would I set the Me.TextboxName = Me.ComboName.Column(3) if I have 4 other field names that are being populated from the combo box?

Bruce

[pbaldy]

The table for this textbox is different than the rest of the form? Odd, but you'll have to save the value manually somehow, unless you can bind the form to a query with both tables in it. More often than not that results in a read-only query though.