Updating the recordsource property on a subform

[MFugill]

Hi. Hope somebody can help, cos this is driving me insane
Using a Navigation Control form, as the user clicks the navigation button to load the appropriate form, I want to be able to control the form's recordset.
I cant get the following to work - I get an error message to the effect that the object does not exist

Code line as follows, where Me. represents the main Navigation form:

Me.NavigationSubform.Form.RecordSource = strSQL

Any thoughts?

[twinnyfo]

MFugill,

Welcome to Bytes!

Although it is possible to reference forms that are ona Navigation Form, it can be complex to get it to work correctly. Your syntax is based upon the normal paradigm of the way it “should” work, but it doesn’t quite work that way.

As I have recommended to everyone else who has been on here scratching their heads over Navigation Forms, I recommend you just use standard forms with some type of switchboard Form to select which form to open. This is the way Access was really designed to work and the Navigation Forms have complexities that for its users.

I know there is a thread or two on our forum that addresses the proper verbiage for referring to Navigation sucbforms, and you may be able to find it. But, in the long run, I do think it is simply easier to use standalone form.

Hope this hepps!

[MFugill]

Hi Twinnyfo,
thanks for your comments. I have taken your advice and abandoned the Navigation form. Coding is much simpler now

[twinnyfo]

Glad the advice was heppful! Let us know if you have any more questions.