Hi folks, I need your help.
I've attached a sample db illustrating the problem I'm experiencing in another db.
Essentially, I have a form bound to a table containing the core data. The form contains 2 list boxes (List1 & List2) both working of the same table. List1 allows the user to select a month/year option which filters List 2 against that selection accordingly. Selecting a record from this flitered list2 will then filter the form for that record and allow the user to edit one or more fields in the record.
To make things that bit smoother, I'm trying to have it so that when I change my selection in List1, the first entry in the newly filtered List2 will automatically be selected which will in turn cause the form to filter for this record. This is to ensure that the form fields are never blank and always tie into a seleced record in List2.
My attempt is causing a Runtime Error 2115..."The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field". The error is being caused by the way I'm filtering the form but I can't see where I'm making the mistake.
Just wondering if someone could have a look at the attached file and see what I should be doing to get around this one?
Many thanks, Dave
I've attached a sample db illustrating the problem I'm experiencing in another db.
Essentially, I have a form bound to a table containing the core data. The form contains 2 list boxes (List1 & List2) both working of the same table. List1 allows the user to select a month/year option which filters List 2 against that selection accordingly. Selecting a record from this flitered list2 will then filter the form for that record and allow the user to edit one or more fields in the record.
To make things that bit smoother, I'm trying to have it so that when I change my selection in List1, the first entry in the newly filtered List2 will automatically be selected which will in turn cause the form to filter for this record. This is to ensure that the form fields are never blank and always tie into a seleced record in List2.
My attempt is causing a Runtime Error 2115..."The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field". The error is being caused by the way I'm filtering the form but I can't see where I'm making the mistake.
Just wondering if someone could have a look at the attached file and see what I should be doing to get around this one?
Many thanks, Dave
