briokas
asked on
Finding a record using criteria for bound controls
I am trying to add an extra textbox/combo to help me insert search criteria so that users can go to a particular record without having to resort to the use of findnext and findprevious only.
I tried to do it like this:
Private Sub FindSICode_AfterUpdate()
DoCmd.FindRecord Me.FindSICode
End Sub
This keeps on giving me the error 'Ther command or action "FindRecord" isnt available now'
This can easily be implemented when u r dealing with unbound controls but I would like to find out if its possible to do it with bound controls.Thanx a lot
I tried to do it like this:
Private Sub FindSICode_AfterUpdate()
DoCmd.FindRecord Me.FindSICode
End Sub
This keeps on giving me the error 'Ther command or action "FindRecord" isnt available now'
This can easily be implemented when u r dealing with unbound controls but I would like to find out if its possible to do it with bound controls.Thanx a lot
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tried that method it didnt help me I guess the only alternative is to use unbound controls
also, text1 would be the place where u enter ur search criteria for field1