Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 986
  • Last Modified:

MSACCESS 2007 and QBF

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
rhgi
Asked:
rhgi
1 Solution
 
omgangIT ManagerCommented:
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
 
rhgiAuthor Commented:
I forgot the [Forms] part of the qualification.  Thanks for prompting me!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now