Search results

That worked like a charm. Thanks so much CJ! For future reference if anyone else has this problem I went into the subform record source and saved that as its own query (qrySearch), then I pulled that into a second query that referenced the second table, made a join between qrySearch and the table.

Aha! That I understand. Okay, let me tinker with it a bit and see if I can make it work.

Hi CJ, thanks for your lightning-speed respose! I'm a little confused about what you mean? Right now I have a button on the form that runs the query that contains the SQL code I posted because I don't always need the query to run, only when I need that additional information from the other...

Hello! I'm new here but I've used this forum quite extensively in the past to figure out answers to my questions. I have a moderate amount of Access experience, and I'm using Access 2010, (though the database in question is 2002 - 2003 format). I looked through this forum and have searched on...