On a form, you normally implement cascading combo boxes by using a Parameter query in the second combo that points to the first. The parameter looks like:
[Forms]![MyForm]![Combo1]
When the combo boxes are on a subform, however, the form that's inside the subform control isn't part of the Forms collection. You have to first reference the outer form, then the subform control, and finally the Form property of that control. So, a cascade parameter has to look like:
[Forms]![OuterForm]![SubformControl].[Form]![Combo1]
Note that you must use the name of the subform control - which isn't necessarily the same as the name of the form inside the control.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Feb 23, 2017, at 4:12 AM, jamshi285 jamshi285 jamshi285@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi everyone
Can any one help me to create a cascading combo box in subform.
I am getting the value in single form but when i try to use in sub form it is not working.
Sent from Yahoo Mail for iPhone
Sent from Yahoo Mail for iPhone
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (42) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar