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

Taking a parameter from recordsource of form to open a new form in ms access vba.

P: 99
I have a procedure that opens a form based on a particular "A_ID".This A_ID is present in the recordsource of a subform but it's not displayed on the same.How do I refer to this A_ID so as to open the form?
As of now A_ID used to come from a combobox which had A_ID in its select query.
Expand|Select|Wrap|Line Numbers
  1. forms![frmMain]![cboID]
Now, I do not know how do I take A_ID from the subform as it is not displayed in any of the controls.
Mar 5 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
See if the fields are available (The RecordSource of a bound form has fields). If not, then you may need to include a hidden control bound to that field for this purpose.
Mar 5 '12 #2

Post your reply

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