R
Rose B
I am setting the values for a combo box in a form(s) via a query that
'filters' the results with criteria based upon the vales of other fields on
the form. The combo is a field that is bound. However, this is giving all
kinds of problems ranging from Access completely crashing to being asked for
the parameter values of those criteria fields when closing the form. I have
tried making the combo an unbound field and then setting the value of the
bound field to that unbound field after update, but that stilll leads to the
same issues. How can I do this?
As example - I have a form with ClientID, which the user selects and then
based upon that I will populate the values of a combo box for invoices which
selects all invoices for that client. The user should then select the
relevant invoice and the invoice number is then stored in the table
underlying the form.
(I have two other forms doing similar things, the more complex one is a
continous sub-form which contains a combo with a query behind that uses two
other fields from the subform - if I just enter the main form a few times in
succession it crashes Access!
Any help gratefully received!!
'filters' the results with criteria based upon the vales of other fields on
the form. The combo is a field that is bound. However, this is giving all
kinds of problems ranging from Access completely crashing to being asked for
the parameter values of those criteria fields when closing the form. I have
tried making the combo an unbound field and then setting the value of the
bound field to that unbound field after update, but that stilll leads to the
same issues. How can I do this?
As example - I have a form with ClientID, which the user selects and then
based upon that I will populate the values of a combo box for invoices which
selects all invoices for that client. The user should then select the
relevant invoice and the invoice number is then stored in the table
underlying the form.
(I have two other forms doing similar things, the more complex one is a
continous sub-form which contains a combo with a query behind that uses two
other fields from the subform - if I just enter the main form a few times in
succession it crashes Access!
Any help gratefully received!!