2000 form via 2003

S

scojerroc

I have a form where I'm using two dropdown boxes in order to select a record.
I built this portion in a 2000 database using Access 2003. The record
select process works fine when I am using it on '03, but does not when using
'00. Below is the code for the two combo boxes. ComboContract is updated
before ComboLoannum. Is there something in the code that '00 does not
recognize? Any suggestions would be appreciated.


Private Sub ComboLoannum_AfterUpdate()
DoCmd.ApplyFilter , "LOANNUM = forms![frmSecondCheck].[ComboLoannum]"
End Sub
---------------------
Private Sub ComboLoannum_Change()
Me.LOCK = fOSUserName()
DoCmd.RunCommand acCmdSaveRecord
Forms![frmSecondCheck].ACTIVEMERS.SetFocus
Me.ComboLoannum.Enabled = False
Me.ComboLoannum.Visible = False
End Sub
--------------------
Private Sub ComboContract_AfterUpdate()
Me.LOCK = Null
DoCmd.RunCommand acCmdSaveRecord
Me.FilterOn = False
DoCmd.GoToRecord , , acFirst
Me.ComboLoannum = Null
Me.ComboLoannum.Requery
Me.ComboLoannum.Enabled = True
Me.ComboLoannum.Visible = True
End Sub
 
D

Designing-Systems.com

hi,
Check your reference library to verify that there is no missing references.

Regards,
 
Top