Search results

Hi I'm trying to get information from one subform to another. Everything works fine if I SELECT * FROM tbl but if I add a WHERE clause or try to SELECT a column name I can't see any record information. Here is my code. Can anyone please tell me what I'm doing wrong? Thanks! Dim rst As...