i try and follow everything from sample that wayne gave. but it not working for mine, subform not update.
i hope any expert will help me to find out what is my mistake. attached my test program.
i want to update the subform list by selecting Date from form,
table use - tblDailyDetails_Deliver...
done.. but at If.. Else expression have error
ive change it to this code
Dim strRS As String
Dim rst As DAO.Recordset
strRS = " Select * from [t_CC] WHERE [CC] ='" & Me.CC & "' "
Set rst = CurrentDb.OpenRecordset(strRS)
If Forms!f_Main.Coverage =...
not working at all
Private Sub Command51_Click()
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("Select * from [t_CC] where [CC] = """ & Forms!f_Main.CC & """")
If Forms!f_Main.Coverage = "Comprehensive" Then
Forms!f_Main.BasicPremium =...
wonder why no value at BasicPremium after i change value at CC..
even i make command button, it not work either..
it work fine at NCD combobox..
help me plz...
as a title, how? coz i want make report based on value that calculated at form where data value is unbound..
i use ms access 2K
i make calculation on my form.. and ofcoz the result is in unbound textbox.. but when i try to make report of the result, it need table or query to make it..
so i...