Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Populate 2nd form with 1st form, subform combobox value, column (1)

Posted on 2014-01-15
2
406 Views
Last Modified: 2014-01-15
What is wrong with this code?

=[Forms]![frmCustomers]![subfrmPets].[Form]![cboSpecies.Column(1)]
0
Comment
Question by:SteveL13
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 39783052
Try
=[Forms]![frmCustomers]![subfrmPets].[Form]!cboSpecies.Column(1)
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39783063
If this is a control source , try:

=[Forms]![frmCustomers]![subfrmPets].[Form]![cboSpecies].Column(1)

But that will not work in a query.  In a query, you would need to create a function that would return that value, something like:

PublicFunction fnSpecies(ColNum) as variant

    fnSpecies = [Forms]![frmCustomers]![subfrmPets].[Form]![cboSpecies].Column(ColNum)

End Function
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question