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.

 

[Pat Hartman]

It is pretty easy to create your own split form. The only advantage the built-in one gives you is the splitter. If you don't need the splitter, build your own. It only takes two lines of code. In the Current event of the list subform, you copy the FK to a hidden control on the main form and then requery the main form. The main form is bound to a query that references the hidden control for criteria.

 

[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

 

[Pat Hartman]

Set the visible property of a control to No to hide it. For my own sanity, I make the background of "hidden" controls a bright color like yellow so they stand out when I open the form in design view.

 

[Steven.Ashby82]

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

Thanks

 

[Pat Hartman]