Autolookup with cascading combo boxes

[lmnop7854]

Ok, I have read every different thread about both of these subjects, and I am still unenlightened (read frustrated).

I have a form I have developed that has 3 comboboxes, all cascading, and they all work, thanks to SJ McAbney. I followed his directions to the letter, and everything is great!

However, I need the Autolookup function to work in conjunction with them. Here is the scenario:

The form is bound to a query which holds all the data I need to see on the form. The fields are Provider Name, Medicare ID, Begin Date, End Date, and Contract Type. I need the combo box attached to Provider Name to pull in the Medicare ID for that Provider, and then the next combo, Begin Date, pulls in the End Date for that Begin Date, and then the final combo, Contract Type, is based on the 2 previous combos.

The combos all work exactly as they should, but neither the Medicare ID or the End Date are pulling in. I have looked at all of the samples on the forum, and I can't get them to work. I am afraid to fool around with the combos, because it took me forever to get those going, also.

Any ideas would be helpful. Thanks.

Lisa

 

[smercer]

The combos all work exactly as they should, but neither the Medicare ID or the End Date are pulling in.
Lisa

1) Check the fields in your query.

2) Check the references in the combo boxes so that they are referecing the query