Cascading Combo Box Problem

[denileigh]

Hello all,

I have two combo boxes. One with the customer and one with the customer contact. These boxes seem to be working fine however, after you select the customer and then the customer contact box updates, it isn't allowing me to choose the contact. Nothing happens when you click.

Can anyone help?

Thanks so much!

 

[jdraw]

Watch these 2 videos
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

Good luck

 

[denileigh]

Thank you! I believe I got it! Now I've run into a different issue. There is a subform on the main form both linked by the Job number. The subform contains all the details of the job. It seems to work fine and when you preview the wordorder report the data is all there however, when you return to the main screen it disappears.

Any records before today all show up when you flip through them however, the new ones added this morning don't although the data is clearly there because it shows on the report.

Can you help?

Thanks again!

 

[jdraw]

Can you post a zip of your data base? Remove anything private/confidential.

 

[denileigh]

It's too big BUT I've narrowed down the issue to another problem. Everything works fine BUT I keep having to refresh the SQL backend linked tables. Why?

 

[jdraw]

Do you get any error messages?

 

[denileigh]

Yes - it says ODBC--connection to 'SQL ServerSERVER\SQLExpress' failed. When I refresh the linked tables all is well. But I have to refresh constantly.

 

[denileigh]

I posted in the SQL section. Thanks!