Combo box and form problem

[iidx036]

Hi everyone,

It's been a long while since I posted on here and it's great to be back!

It's also been a while since I used Access so I feel a complete newbie all over again! I hope you can help ...

I have 2 tables.

Table A contains Job information such as the date, order number etc.

Table B contains different room sizes in houses. This is split by the owner of the property (there are 2) and the individual property names which are unique. Each property then has a value for each room size.

What I would like to do is have list or combo box to select an owner name from table B on this form which when selected pulls in the relevant property names into another combo box. Then when the property name is selected I would like to pull in all the room sizes for that property.

I have been trying to get this working to no avail as yet ... I would really appreciate any help or pointers that you guys could give.

Many thanks and glad to be back!

Cheers

 

[boblarson]

That would be a cascading combo and here's a sample:
http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip

 

[iidx036]

That would be a cascading combo and here's a sample:
http://downloads.btabdevelopment.com/Samples/combos/CascadingCombosSample.zip

Thats great Bob thankyou very much I got the cascading working from checking out that example.

One question I have though is how do I manage to save the contents of the combo boxes from Table B (which is simply data to bring into the form) to Table A which will hold all the info for an individual job that has been completed on a property?

Many thanks.

 

[fibayne]

add a text box to table A to hold the data then set the control source of the combo box to the text box in table A ...hope this helps..Fi

 

[iidx036]

add a text box to table A to hold the data then set the control source of the combo box to the text box in table A ...hope this helps..Fi

Excellent! Thanks Fi that works a treat!

Cheers

 

[fibayne]

Glad I was fanally able to help someone instead of being the other way around