Solved

Access Parameter Values in Form

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

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