When changing combo box, form fields don't update.

[jmowrey]

In the main form of our database, there is a combo box that drops down to list all of our sites. When selecting each one the form should update to show things like address, status, phone number, and so on. Well, it works great for the first site selected in the combo box. After that, no matter what site you pick, the info will not update in the form. Everything just stays the same.

The wierdest part of this problem is that it only exists on machines with Access 2000, but works fine on Access 2003. We are in the process of upgrading to Office 2K3 right now and we have tested this database on a machine that has been upgraded already. No problems, works great. We are still in the pilot phase of our deployment and with 55,000 machines to go...upgrading everyone just isn't feasable right now. The extra special part is that there are a handful of machines with Access 2K that it does work on. I've also heard rumors of some myserious 'fix' that 'somebody' applied to these machines to make it work.

So...is this a coding problem?, and application issue? We've tried reimaging machines, reloading Access, all to no avail.

 

[PHV]

The 2k office components are known to be buggy if not patched.
You may consider applying the services pack.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

Posy the code in the after update event of the combo

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[jmowrey]

Here is the code you requested Ken. If you want/need more please just say so. thanks to all for any help.

Private Sub uSiteId_AfterUpdate()

    Dim Tmp As Variant

    DoCmd.ApplyFilter , "[Sys_Cd] = Forms![Site_Master]![uSysCd] AND [Site_Id]= Forms![Site_Master]![uSiteId]"

    Tmp = EnableControls("Detail", True)

    loc_addr_ln1.SetFocus

End Sub