Solved

Access Parameter Values in Form

Posted on 2009-07-13
3
203 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
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

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…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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.

864 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now