Recent content by sko

Well I finally figured it out!:) As it turns out I had different data types on the diagNo and diag8. THANK YOU SO MUCH!!!! SKO

Wayne, I can't post the db I'm working on so I made a small sample of what I'm trying to achieve. Of course this sample works so I'm not sure why my real db isn't working? At least I know that my SELECT statement works Thanks to you. I'll have to go through everything to see if I can figure out...

Sorry, I'm not sure how to do that. I'm new to access. I think the recordset is closed when I use the where clause because the rst.EOF says Operation is not allowed when the object is closed. When I don't use the where clause I get true or false. by the way one set is numbers on is a string...

Thanks Wayne but it looks like the recordset isn't open now. Any Ideas?

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...