Jawabannya mirip dengan pertanyaan mas Agus Erwanto,
Buat query1 Jadikan source, untuk sub form ;
SELECT class.id_class, Month([Month]) AS bulan, class.Stud_no, class.Kelas, class.DateofStarting, class.days, class.DateofTest, class.Jam, class.Teacher, class.Room
FROM class
WHERE (((Month([Month]))=[forms]![mainF_jmlsiswa]![cmbBulan]) AND ((class.Kelas)=[forms]![mainF_jmlsiswa]![cmbKelas]));
Link master and child saya hilangkan, filter nya ada pada form master dan subform dengan source query1.
WHERE (((Month([Month]))=[forms]![mainF_jmlsiswa]![cmbBulan]) AND ((class.Kelas)=[forms]![mainF_jmlsiswa]![cmbKelas]));
Pada kedua combo box buat event;
Private Sub cmbBulan_AfterUpdate()
Me.Refresh
End Sub
Private Sub cmbKelas_AfterUpdate()
Me.Refresh
End Sub
Hasilnya spt ini;
\
Thank you | Terima Kasih | Matur Suksema
Sumiyanto
http://cakyanto.wordpress.com/
http://mugi.or.id/blogs/sumiyanto/
From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of karim safril
Sent: Saturday, January 26, 2013 11:07 AM
To: belajar-access@yahoogroups.com
Subject: Re: [belajar-access] from and subform [1 Attachment]
[Attachment(s) from karim safril included below]
saya dah coba dan hasilnya syntax error in query expression....
berikut saya berikan file attachment, tolong dicek kesalahannya dimana??
makasih banyak sebelumnya...
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar