Hi all 
I'm using a subform datasheet that I want to use as a list of current records for the parent form. I want to be able to click on a record which fires oncurrent to search for the record in the parent form.
I've used this technique elsewhere - but only when the datasheet isn't a direct subform of the one I'm searching in.
The obvious problem being that doing a search on the parent form causes oncurrent to trigger... DOH. I've tried to filter the subform, which would mean I could unlink the subform, but you can't do that (unless there's a technique I'm not aware of)
I could redesign the form, but that's gonna be rather messy, and I'm sure there's a way around this....
cheers
Mike

I'm using a subform datasheet that I want to use as a list of current records for the parent form. I want to be able to click on a record which fires oncurrent to search for the record in the parent form.
I've used this technique elsewhere - but only when the datasheet isn't a direct subform of the one I'm searching in.
The obvious problem being that doing a search on the parent form causes oncurrent to trigger... DOH. I've tried to filter the subform, which would mean I could unlink the subform, but you can't do that (unless there's a technique I'm not aware of)
I could redesign the form, but that's gonna be rather messy, and I'm sure there's a way around this....
cheers
Mike