Linked subform with oncurrent event

[mrlw00r]

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

 

[Jack Cowley]

Hmmm. Why not create a combo box using the Wizard and on the first screen select the 3rd item, "Find a record....". The combo box will display the records and selecting one will display it in the form. No need for a subform...

I hope I understood what it is you are trying to do....

Jack

 

[mrlw00r]

Ahhh yes - that would do the trick. I hadn't thought about doing that because the rest of the interface uses datasheets to display lists and it would be nice to be able to keep the aesthetics of the thing regular.
I'll give that a go anyway, cos I need a solution!

ta, Mike

 

[mrlw00r]

I haven't work on this now for a few days and I saw the light just now...
I looked at the record that is in common in the whole form, and placed the two parts of the current form as subforms in a new one. One subform contains details of the record, the other contains a list of the different records. The main form is then bound to the entity in common, and so I can link the subforms on the required field. When I open the main form I filter that to the common record and it all works rather nicely
Cheers for other tip though - I think that'll work nicely somewhere else!

Mike

 

[Jack Cowley]

I am glad you found a solution that worked for you!

Jack