By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,818 Members | 1,381 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,818 IT Pros & Developers. It's quick & easy.

Updating the recordsource property on a subform

P: 2
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:
Expand|Select|Wrap|Line Numbers
  1. Me.NavigationSubform.Form.RecordSource = strSQL
Any thoughts?
3 Weeks Ago #1
Share this Question
Share on Google+
3 Replies

Expert Mod 2.5K+
P: 3,278

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!
3 Weeks Ago #2

P: 2
Hi Twinnyfo,
thanks for your comments. I have taken your advice and abandoned the Navigation form. Coding is much simpler now
2 Weeks Ago #3

Expert Mod 2.5K+
P: 3,278
Glad the advice was heppful! Let us know if you have any more questions.
2 Weeks Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.