Nested subforms problem

[Kyriakos]

Hi to everyone. I work for a vet firm and I have this problem to resolve. On a form (based directly on a table) I have a field named species which is linked with an one to many relationship with anothet field from another table from where it gets its data. Now based on the selection I make from the combo box species (category selection) a new window pop ups and I can choose more detail for each species. I don't know how I'm I going to return the final value back to the main form, so that I could have in the end on the main form displayed the species, the categories and the details...

Can this be solved?
Hope I was clear enough

 

[Dennisk]

on you form create a couple of buttons ok and quit.
create an event handler to close the form.
In the OK button event handler precede the close statement with code to update the calling form.

eg Forms!myCallingFormName!myControl = me!myControlOnThisForm