Hi All.
In child form I have cascade combo boxes. They work fine in case if I open that form to create new record. But if i try to use this form to modify existing record I met the problem. In the form last level of cascade combo boxes is bound and should be populated but rowsource of the combobox has criteria and that not allow to display data. When I remove criteria of cause cascade combo box stop working but in that case it display value of record passed from parent form to modify the record.
How to dynamically change rowsource of combobox:
1. if I open form to create new record then I will use query as rowsource for combobox with criteria
2. if I open form to modify existing record then I will use query as rowsource for combobox without criteria
I will appreciate if someone will show how to do it.
Thanks