Solved

Access Parameter Values in Form

Posted on 2009-07-13
3
210 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

830 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