Babycat
Member
- Local time
- Today, 16:34
- Joined
- Mar 31, 2020
- Messages
- 275
Hello everyone
I have complicated form with MainFrm and three sub-forms. One of them names SubFrmTable which is continuous form
I have 2 questions that would need you help to advise:
1. After set recordsource as above, the forms are flickering crazy, especially when that SQL string returns many records. How to avoid this flickering issue? I have tried to set SubFrmTable visible property to No, then Yes again during RecordSource is being set, also tried to use Application.Echo but the issue remains.
2. Do I need to call Forms!MainFrm.Form!SubFrmTable.Form.Requery to force the form update new datas? If call this line, the flickering is even more
Appreciated your advices
I have complicated form with MainFrm and three sub-forms. One of them names SubFrmTable which is continuous form
Code:
SQL = "SELECT DATATABLE.* " _
& "FROM DATATABLE" _
& "WHERE DATATABLE.Deleted = False " _
& "ORDER BY DATATABLE.Createddate DESC;"
Forms!MainFrm.Form!SubFrmTable.Form.RecordSource = SQL
' Commented out below line
' Forms!MainFrm.Form!SubFrmTable.Form.Requery
I have 2 questions that would need you help to advise:
1. After set recordsource as above, the forms are flickering crazy, especially when that SQL string returns many records. How to avoid this flickering issue? I have tried to set SubFrmTable visible property to No, then Yes again during RecordSource is being set, also tried to use Application.Echo but the issue remains.
2. Do I need to call Forms!MainFrm.Form!SubFrmTable.Form.Requery to force the form update new datas? If call this line, the flickering is even more
Appreciated your advices