Hi, access newbie and first time poster here!
I have a form for entering invoice information. In the main form you choose a client from a combo box, and this filters options in a combo box in the subform to only show contractors currently placed with that client. After trying various ways of applying an AfterUpdate event to make this happen, all seemed to be well at first glance when using this line of code as an AfterUpdate event on the main form combo box:
Forms!formname!subformname.Form!comboboxname.requery
It would correctly show only the relevant contractors in the subform. I entered a handful of invoices to test this, and still all seemed well. They all happened to be related to the same client (Client1). The problem revealed itself only after adding invoices relating to a different client (Client2). This information still displayed correctly, but when going back to previous invoices relating to Client1, the contractor section had gone blank and clicking on the dropdown now showed contractors related to Client2 rather than Client1, even though Client1 was still selected in the main form.
I hope my problem makes sense, and if anyone could point me in the right direction I’d be very grateful!
I have a form for entering invoice information. In the main form you choose a client from a combo box, and this filters options in a combo box in the subform to only show contractors currently placed with that client. After trying various ways of applying an AfterUpdate event to make this happen, all seemed to be well at first glance when using this line of code as an AfterUpdate event on the main form combo box:
Forms!formname!subformname.Form!comboboxname.requery
It would correctly show only the relevant contractors in the subform. I entered a handful of invoices to test this, and still all seemed well. They all happened to be related to the same client (Client1). The problem revealed itself only after adding invoices relating to a different client (Client2). This information still displayed correctly, but when going back to previous invoices relating to Client1, the contractor section had gone blank and clicking on the dropdown now showed contractors related to Client2 rather than Client1, even though Client1 was still selected in the main form.
I hope my problem makes sense, and if anyone could point me in the right direction I’d be very grateful!