I have a combo box which looks up pathology test names based on the discipline selected by the user on the form. Eg a discipline is a 'type' like haematology or biochemistry. The combo field works by using a query as the rowsource and the query criteria specifies that the test displayed must belong to the discipline chosen on the form. So far so good.
On the 'on click' event on the combo field, I have
me.requery
It all works fine except for when a user changes their mind about the discipline - it still brings up the tests associated with the first discipline that they chose and not the second. I've tried all sorts of form refreshing etc but nothing seems to work. What am I doing wrong?
On the 'on click' event on the combo field, I have
me.requery
It all works fine except for when a user changes their mind about the discipline - it still brings up the tests associated with the first discipline that they chose and not the second. I've tried all sorts of form refreshing etc but nothing seems to work. What am I doing wrong?
Last edited: