Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access Parameter Values in Form

Posted on 2009-07-13
3
Medium Priority
?
216 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

604 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