twiggymates
Programmer
I am attempting to filter data in a query set of a particular field in a subform based on data selected in another field. However, as this is a continuous subform this produces errors and erases the data when i enter a new record (or have different data in different records).
At the minute i am filtering using the "form_orderdetails.catogoryid.value" field in a query criteria. Is there anyway of just selecting the field value of the current record?
Wording this is not very easy so please bear with me.
At the minute i am filtering using the "form_orderdetails.catogoryid.value" field in a query criteria. Is there anyway of just selecting the field value of the current record?
Wording this is not very easy so please bear with me.