I have a form where I can select a value in a textbox and combo box (e.g. date and name of analyst)
I have a subform in the above form which is based on a query (let's call it query_for_subform) that returns a few values. Two of the criteria for this query_for_subform uses come from the above textbox and combo box.
When I open the main form in record editing mode, the subform works the way it should since the query is fed with the values present in the textbook and combo box. But if i change the values in the textbox and/or combo box, the subform does not update.
When I open the main form in new record mode, the subform shows nothing since the textbox and combo box is empty. When I fill up the values in the textbox and/or combo box, the subform does not update.
How do I fix this?
I have a subform in the above form which is based on a query (let's call it query_for_subform) that returns a few values. Two of the criteria for this query_for_subform uses come from the above textbox and combo box.
When I open the main form in record editing mode, the subform works the way it should since the query is fed with the values present in the textbook and combo box. But if i change the values in the textbox and/or combo box, the subform does not update.
When I open the main form in new record mode, the subform shows nothing since the textbox and combo box is empty. When I fill up the values in the textbox and/or combo box, the subform does not update.
How do I fix this?