Address form Combo Box help please

[G1ZmO]

I'm sorry if this has been asked before but I've had a look through the forum and tbh some of the answers were more complicated than I could cope with lol

If someone could explain simply how to do this I'd very much appreciate it

I have 2 tables:
Table 1 "Addresses" which contains Company, Address & Postcode
Table 2 "Shipping" which contains Number of pallets, Weights, dimensions, and a combo box for "ship to address" (which doesnt work lol)

and 1 form (which we print and fax) which I'd like to be able to select the company to which the shipment must go (looking it up from the "Addresses" table) and which would then fill the relavent fields on the form for the rest of the address.

I seem to have a mind block on this as I just cant get it to work

PS I'm VERY new to access so "the simpler the better" please

Ta muchly

 

[ansentry]

Have a look at the Northwind Database (it comes with Access). Order, OrderDetails, Products Forms should point you in the right direction.

 

[G1ZmO]

Is the Northwind database supposed to be simple? Afraid its lost me

 

[ColinEssex]

There is an option (the 3rd option) in the ComboBox wizard that allows you to "find a record based on Combo selection"

Col

 

[G1ZmO]

Yes, I managed to get the combo box to find the address record from the address table but it only fills in the company name, not the address or postcode

 

[ColinEssex]

Look at the code behind the Combo and make sure its including the missing fields and posting them to the form.

Col

 

[G1ZmO]

The "code behind the Combo" ? (Im new to this lol)

Btw I made 2 forms, one works and one doesnt but I cant see any difference in the 2 :s

The "Row Source" is
SELECT [Company Addresses].ID, [Company Addresses].Company, [Company Addresses].[Address 1], [Company Addresses].Postcode FROM [Company Addresses];

But thats the same for BOTH forms and one of them wont work

?

 

[G1ZmO]

Any chance someone can take a look at it for me and let me know where Im going wrong?

 

[G1ZmO]

anyone help a newbie?

 

[Smart]

Have a look at the amendments to your database (attached)

Hope this is what you are after

 

[MStCyr]

Any chance someone can take a look at it for me and let me know where Im going wrong?

Hi

I think this will do it for you..

 

[G1ZmO]

Thanks Smart, thats exactly it

How do I reproduce that though if I'm doing it on another database?

Thanks to MStCyr too

 

[ansentry]

Here is your sample back, No Code required to make it work.

 

[G1ZmO]

Thanks for your help folks. However I still dont really understand where I've gone wrong. I started another access database for doing astronomy observation logs with a combo box for the telescope used but, as with the shipping one above, I still cant get it to auto fill the other fields. :s

Does anyone know of a simple "how to " guide for combo boxes? (or can explain where I'm going wrong)

Many thanks again,

(A bit later.......)

I've figured it out
Took a bit of code though so wasnt as simple as I thought it would be
Think I know what Im doing now.
Thanks to all those that helped