Form/subform issue

[ashu.doc]

Hi
I have a main form in which I have added a subform by subform wizard. When I am keeping the subform on the main form page and entering data in subform corresponding to the main form, the data is entering well in the table of main form and subform, but what I want to do is that I make a hyperlink or button on main form which opens that subform and then when I enter the data in subform it should go into the main form corresponding to it.
I have tried to enter the data in subform on separate page but it is not going into main form corresponding to it. The relationship is something like this: and the form and subform I am talking about is Personal details (main form) and Conference (subform).

PLease help
Thanks

[June7]

Don't understand. Why would entering data in subform cause data to enter into 'main' form? What is 'main form page'? If subform is on main form, then it is already 'open' - do you mean make it visible?

Want to provide db for analysis? Follow instructions at bottom of my post.

[ashu.doc]

what I mean is that, can form and subform be on different pages like web? and can I put a hyperlink or button on main form to open subform? I have tried it but when I am entering the conference data attended by the surgeon, it is not going under the same surgeon ID, but when subform is on the same page as main form, everything is working fine, all the data for the conference is going under same surgeon ID.

[June7]

Still don't know what you mean by 'page'.

A form/subform arrangement will synchronize the related records because of the Master/Child links properties of the subform/subreport container control.

Child forms opened independently to new record need code to pass the key value and populate foreign key field.

[ashu.doc]

ok i am sending you the database, have a look:

Surgi-log 1.0.zip

What I mean from "page" is F_Alldetails. So if you see there is a main form F_Alldetails. Then F_patientsdetails, F_surgicaldetails and F_opnotesandcomplications are subforms. Now if I want to add more subforms ( F_conferences, F_presentations) in the same page (F_alldetails) either I just have to show them as forms or as tab control. But I want to put a button or hyperlink on F_alldetails to open the subforms like F_conferences, F_presentations etc as a separate form. Also want to keep the data of forms and subforms related.

Thanks

[June7]

My previous reply still applies. In addition, if you want to open form with only records related to the record on F_Alldetails, need filter criteria, like:

DoCmd.OpenForm "F_conferences", , , "SurgeonID=" & Me.SurgeonID

[ashu.doc]

Hi June
You might be saying right but I cant understand your answer, if you have understood my question can you do that on my database forms and attach to your reply please.

thanks.

[June7]

Guess I don't understand what you want, because my suggestion is a simple code edit. If you want a button Click event to open another form that shows only records related to record on F_AllDetails, then use filter criteria in the OpenForm code. SurgeonID is the primary key of F_AllDetails so I assume that is the criteria to use when opening other forms.

I am not going to try to modify and test your db. As I said, this is a simple edit. Create button, type code.

[ashu.doc]

No its not that I want a button to open a form to show only records related to record on F_AllDetails. I want a button on F_alldetails to open a subform F_conferences and when I enter the data in conferences on any occassion it should populate the table of conferences with same surgeon ID from which that subform is opened from. and if you look in my database the table Personal details has SurgeonID as primary key is related as one to many with conference table ( SurgeonID as foreign key), so when I am creating that subform as linked one it is not populating the table as I want but when I am putting that subform in the main form itself, it is populating the table as I want, why is it like that?

[June7]

A subform is created with a subform/subreport container control on another form/report. A sub is already 'open' when the parent opens. The subform/subreport container control synchronizes related records of main and sub with Master/Child links properties. The primary key of parent form will automatically save as foreign key in the subform record.

If you are actually opening 'subform' independently then it is not really a 'subform' and it will not automatically synchronize records with 'parent' form. Synchronization would have to be controlled with code, hence my suggested VBA because I use only VBA (not macros).

So which do you want - a subform or an independent form (the easy way or the hard way)?