Perhaps I’m being thick – but I had a simple little edit form that used a data source ‘select * from Individual’ and provided edit functionality to the fields such as name and address.
I wanted to, on the same form, alloweentry of a lookup value. So I created an unbound label ‘lookfor’ and coded the following event on exit
Private Sub Lookfor_Exit(Cancel As Integer)
Me.Filter = “((IndividualId = ” & Me.Lookfor & “))”
Me.FilterOn = True
End Sub
It does exactly what I want, displaying the correct record for the individual with that Id. However, it also makes the form uneditable which is NOT what I want. (The only field that gets the focus is Lookfor.)
Is there a way of allowing field updates within this filtered form – or should I be doing this in an entirely different way?
Andrew
that seems to work very.
