Query with subform

alpertunga65

Registered User.
Local time
Today, 08:02
Joined
Mar 15, 2013
Messages
21
Hi,

I am trying to built a database but I have a problem in making query with subform.

I have 2 tables and 4 forms

Forms are ChzList, ChzList_Altform, ChzSnf and ChzSnf_Altform,
ChzSnf is the main form and others are subforms on it.

I can query Form ChzSnf by Form ChzSnf_Altform using the code below;

Private Sub Form_Click()
Dim rs As Object

Set rs = Forms![ChzSnf].Recordset.Clone
rs.FindFirst "[ChzSnfID] = " & Str(Nz(Me![ChzSnfID], 0))
If Not rs.EOF Then Forms![ChzSnf].Bookmark = rs.Bookmark


End Sub

Unfortunately the same method didn't work for the second part Form ChzList by Form ChzList_Altform.

here is my attachment...

I need your help...
Thanks.
 

Attachments

Users who are viewing this thread

Back
Top Bottom