?
Solved

Access Parameter Values in Form

Posted on 2009-07-13
3
Medium Priority
?
213 Views
Last Modified: 2013-11-28
The attached db is launched by Form "Frm_Start Up," that requires the user to select an [Analyst] and a [Billing_ID]. Then, form {Frm_Audit Information] is launced by button "Proceed to Audit Information."

'Frm_Audit Information" is based on query "Qry_Audit Information." When opened in design view, you will see where the fields for this query/form are based on what the user selects for [Analyst_ID] and [Billing_ID] in "Frm_Start Up."

The glitch is if "Qry_Audit Information" just has the parameter value for [Billing_ID] from :Frm Start Up" then the fields are populated in "Frm_Audit Information." However, if the paramater values are both [Analyst_ID] and [Billing_ID] or just [Analyst_ID] the fields do not get populated.

I am looking for a resolution that will allow all fields to populated, including [Analyst_ID] in "Frm_Audit Information."

Thanks.
Analyst-ID.mdb
0
Comment
Question by:tahirih
[X]
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
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 24848126
1. The basic issue is that you are trying to Open the form with "stLinkCriteria", yet you have not set it.

Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria=???

    stDocName = "Frm_Audit Information"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

2. The second issue is that you have a textbox on top of the Billing_ID combobox.
?
Why

3. Only about 5 of the 15 fields in Source Audit are filled in.
So when you say:
<looking for a resolution that will allow *all* fields to populated, including [Analyst_ID] in "Frm_Audit Information.">
I am a bit confused.

4. You cannot use the first form to Filter *And* add record to the second form. (if that is what you are trying to do)

Can you clearly state what your ultimate goal is with this system?
Something does not seem quite right with your design...

JeffCoachman

0
 

Author Comment

by:tahirih
ID: 24848626
I slept on it, and caught my own issue. It is directly related to what you have said, that there is a flaw in the design. Let me work on this a bit more.

Thanks.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24848691
;-)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

777 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