And yet another database question~!

Hey guys,,

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,


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!