I've been setting Datasheet Forms Record source to a query then each fields control source via the dropdown in Properties - Data Tab.
Now I'm wondering if instead you can set Form record souce to the actual sql string insted of the query name, and not need the query. But then the control source dropdown doesnt let me select a field. It's empty. I can type it in, but it doesn't work.
So is this idea wrong, there must be an actual query ?
Now I'm wondering if instead you can set Form record souce to the actual sql string insted of the query name, and not need the query. But then the control source dropdown doesnt let me select a field. It's empty. I can type it in, but it doesn't work.
So is this idea wrong, there must be an actual query ?