It looks like you're new here. If you want to get involved, click one of these buttons!
I just keep running into these problems! Most of which ya'll have nice easy solutions for. Here's my new delima. I've added a data control to my form, and using code, I've set the Recordsource using an SQL statement that specifies the fields, and conditions of the fields that I want the data control to contain.
I'm taking my fields from multiple tables and using an Inner Join to connect them.... BUT for some reason the only fields I can access (via code) are of just my primary table... the others don't seem to exist. Anyone have a clue as to what I may be doing wrong?
Thanks in Advance,