Solved

MSACCESS 2007 and QBF

Posted on 2010-09-15
2
912 Views
Last Modified: 2012-05-10
I've set up a form, QBF form,  which I base user inquiries from.  In this form I have two fields, orders and lastname.  orders is a textbox and when it is filled in with an order number a macro is called that displays a "results" form,  which is based on a query and subquery.  The Query selects the data by using the input form the original QBF form. This all works just fine.  The 2nd field is a combo box, a bit more tricky apparently,  the combo field is populated by an underlying query into a table in the database.  The item that a user selects is found by using Combo13 or whatever name you give the box .value.  So, I set up the underlying query to refer to the selected value as combo13.value.  However, when I run the form I receive a prompt from the query for combo13.value.  I know that combo13.value has the selected last name at the "before update" event. I displayed, via a msgbox, combo13.value and it contained the value that was selected.  Where am I going wrong? Oh, by the way, I'm using MS/Access 2007
0
Comment
Question by:rhgi
2 Comments
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
ID: 33682646
In the query you need to refer to the fully qualified form control.
[Forms]![TheNameOfTheForm]![Combo13]

Post the SQL of you query
OM Gang
0
 

Author Closing Comment

by:rhgi
ID: 33691680
I forgot the [Forms] part of the qualification.  Thanks for prompting me!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
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…
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…

914 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

20 Experts available now in Live!

Get 1:1 Help Now