Locking Row Source?

[Steven.Ashby82]

Dear All

I'm having problems with my split form. (I know that is already causing some to scream no!)

Is there a way to lock the row source fields in the properties menu as currently it keeps creating exceptions (WHERE) onto the end of the SQL this is subsequently causing me major issues in the view of the form/datasheet as fields keep appearing as blank when there is actually values stored within the table.

I hope this is clear.

I've been going crazy trying to understand why it has been happening and I now hope this is the reason.

 

[Steven.Ashby82]

Thanks Pat,

Although I've been fairly busy on here I'm still getting into the terminology and what not. I've heard of hidden controls before but not understood them. How do I do this?

Kind Regards
Steve

 

[Steven.Ashby82]

Sorry Pat do you have an example of this I could see?

Thanks