Cascading Combo Boxes

[HDEvKev]

I am trying to create a cascading combo box that will allow the user to select a lot code and from there select an operation listed in that lot code. I have never worked with cascading combo boxes. I have a table that has every operation for every lot code. What's the best way to do this.

 

[pbaldy]

This should get you started:

http://www.baldyweb.com/CascadingCombo.htm

 

[HDEvKev]

I Must be missing something. When I get to the second Combo Box, there is nothing in there.

 

[pbaldy]

Hard to say without seeing it. Make sure the column count and widths properties match up to the row source.

 

[HDEvKev]

My Column width was different. Now combo box 2 shows the operation, but it does not store the operation I select in the Operation Field.

 

[pbaldy]

Does the combo have a control source of the appropriate field in the table?

 

[HDEvKev]

No it doesn't

 

[pbaldy]

Hard for it to save to the table without being told where to save.

 

[HDEvKev]

Even when I put the field in the control, it doesn't save it to the record.

 

[pbaldy]

Can you post the db here?

 

[HDEvKev]

not sure how to post. Never did that before

 

[pbaldy]

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[HDEvKev]

Here is a short version

 

[pbaldy]

Your code in the after update event of Combo11 takes out the selection. I wouldn't expect any code there.

 

[HDEvKev]

Now it works. I forgot that code was in that event from an earlier trial. Thanks for the help and dealing with my inexperience

 

[pbaldy]

Happy to help!