Hello,
I am using Access 2007 and have a database that has a form utilizing a combobox [QueryData] to allow the user to select a record to view/edit. The data in [QueryData] is the result of a UNION, so the location of the record to view/edit could be on one of a couple different tables.
The problem I am having is that this form uses its subform as the view/edit window for the record. The subform is not visible until the user selects a record and then the "View" button. I have not been successful in changing the RecordSource and/or the Filter for the subform. I've tried...
Any assistance would be awesome!
I am using Access 2007 and have a database that has a form utilizing a combobox [QueryData] to allow the user to select a record to view/edit. The data in [QueryData] is the result of a UNION, so the location of the record to view/edit could be on one of a couple different tables.
The problem I am having is that this form uses its subform as the view/edit window for the record. The subform is not visible until the user selects a record and then the "View" button. I have not been successful in changing the RecordSource and/or the Filter for the subform. I've tried...
Code:
Private Sub btnView_Click()
Me!View.Form.RecordSource = "Jobs"
Me!ViewEntry.Form.Filter = "JobID=Forms!Review_Form!QueryData.Value"
Me!ViewEntry.Requery
Me!ViewEntry.Form.Visible = True
End Sub