Form Opening

[Alex Motilal]

Dear Experts,
I am creating a Database for Genealogy.

I do have 3 Forms:
1. PersonFrm in which Persons can be added & in the subform their children can be added.
2. PersonsListFrm which shows all the Persons.
3. Main Menu

When the PERSONS button is clicked, the PersonFrm will open as blank (The Load Event is DoCmd.GoToRecord , , acNewRec)

When a PersonID in in the PersonsListFrm is clicked, the PersonFrm should open with that particular Person's data. I tried this on the Click Event: DoCmd.OpenForm "PersonFrm", , , "[PersonID]=" & Me.PersonID
However, the Form is opening as blank only. This may be due to the Load event of the PersonsFrm



I need your help to solve this problem.

Thanks
Alex

[Gicu]

Few ways to do this but you have to remove that line of code from the Load event and instead put after DoCmd.OpenForm "PersonFrm" in the click event of the PERSONS button.
Another way that could work is using OpenArgs when calling the PersonFrm and testing for that in the Open event of the PersonFrm (if NZ(Me.OpenArgs"")<>"" then FIndThatID Else GotoNewRecord).

Cheers,

[Micron]

I can't figure out what you're doing. There is a form with a subform? Some how I think not but then again...
So maybe from your main menu, provide the option to open showing all vs open to add new (if we're talking about opening the personfrm different ways). If add new, do as you're doing. If not, don't GoToRecord,,acNewRec. The option could be a combo from which they choose if you think there might be other methods of opening in the future, or a frame with 2 option buttons. You might want to review how to add and deal with a frame and it's options.