Opening form with defined combobox value

[Kivan]

Hi.

I have two tables. People and Organization. In the people table you can choose organization from organization table (combobox). People form has fields Name etc. and organization (query IDOrg, OrgName descending).



I have two forms. First form is frmOrganization with subform of people (members of org). Second form is frmPerson.
On frmOrganization I would like to have a button which would add new person to organization (this person does not exist in the people table yet, its absolutely new). So after clicking on this button I would like to see frmPerson where I could put new data BUT the name of organization would be there already (taken from frmOrganization).
And I think it should be like below, but I dont know how to define OpenArgs. I was trying hard, but it seems I'm not skilled enough with VBA.

Private Sub AddNew_Click()
DoCmd.OpenForm "frmPerson", , , , acFormAdd, , 'There is my issue'
End Sub

Thank you for your time .

[R_Badger]

You need to read a bit on openargs (try here)

Basically it passes a string to the me.openargs property on the object (e.g. forms/reports) it would open.

so, for instance you could have it like:

Private Sub AddNew_Click() 
DoCmd.OpenForm "frmPerson", , , , acFormAdd, , "NewUser" 
End Sub

Then on frmPerson use the Form_Load event

If me.openargs="NewUser" then
[forms]![frmperson]![control_name]=[forms]![frmorganisation]![control_name]
endif

[Kivan]

Your solution works perfectly. Thanks a lot .