Call a form from a subform

[Sequel]

I got a father form named "frmsearch", it's also contains a subform
"sfsearch" which would open a form name "frmnotice". If I click on any
register inside a subform, it should open the "frmnotice" with the data
selected. In order to show the data to the user. Any help will be
welcome...Thx a lot.

 

[Allen Browne]

To open frmNotice to a particular record, use OpenForm with a
WhereCondition.

Use whatever event suits you, e.g. the Click of a command button, or the
DblClick of a control.

Example event procedure, assuming a numeric field named ID:
Dim strWhere As String
If Not IsNull(Me.[ID]) Then
strWhere = "[ID] = " & Me.[ID]
DoCmd.OpenForm "frmPreview", WhereCondition:= strWhere
End If

If ID is a text field (not a number field), you need extra quotes. Here's
how:
http://allenbrowne.com/casu-17.html