B
Bongard
Hi, I am trying to insert a find record option within one of my forms.
I have a combo box that lists all the loan numbers in the table and
allows the user to select which loan number he wants to select. Once
this number is selected I want the user to be brought straight to that
record.
My code looks like this:
Private Sub findcmd_AfterUpdate()
DoCmd.FindRecord findwhat = [findcmd]
Me.[Loan Number].SetFocus
End Sub
where findcmd is the name of the combo box that gets filled in by the
user. However, when you selct a loan number from the little dropdown it
gives me the error "A macro set to one of the current field's
properties failed because of an error in a FindRecord action argument."
I am not really sure what this means or how to go about solving my
problem.
Thanks in advance!
I have a combo box that lists all the loan numbers in the table and
allows the user to select which loan number he wants to select. Once
this number is selected I want the user to be brought straight to that
record.
My code looks like this:
Private Sub findcmd_AfterUpdate()
DoCmd.FindRecord findwhat = [findcmd]
Me.[Loan Number].SetFocus
End Sub
where findcmd is the name of the combo box that gets filled in by the
user. However, when you selct a loan number from the little dropdown it
gives me the error "A macro set to one of the current field's
properties failed because of an error in a FindRecord action argument."
I am not really sure what this means or how to go about solving my
problem.
Thanks in advance!