Hello
I am currently making a database for my co-op placement. I have had zero experience with Access prior to this experience, so there have been many bumps along the way. I am hoping to receive some guidance.
I have a number of text boxes that I have successfully set up, that when a name is typed in them, and a search button is clicked, a query is activated and filters appropriately to what I have typed. However, I have wish to add a search box that filters data from another query, in my case these are PID which are numbers representing property. Many PIDs can be owned by one person, which is why I have kept them in separate tables and queries to stop repetition of other data.
Is it possible that one could type a PID into a text box, click a search button, and cause two queries to be activated and filter more than one query at a time ( thus revealing the desired PID and its associated owner). I will add the very basic SQL I made to produce a functioning single query filter. I learned this from a youtube video so I'm not sure if this is a 'good' way to do it. Again, i'm new to this and am looking for guidance.
Thank you
Wesley
SQL:
Private Sub Command68_Click()
Dim SQL As String
SQL = "qry_Contacts_WHO"
Me.Form.RecordSource = SQL
Me.Form.Requery