Unbound field results are different then Query w/the same criteria

From: drdunit (drdunit.17d2yc_at_nospam.MSAccessForum.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 16:24:20 -0500

I have a good understanding of relational databases, and have created a
hand full, but it's not what I do full time and I am seriously lacking
in the terms and definitions dept.

First some back ground>>
Trying to create an Training Evaluation DB, in which there will be 2
front ends; an eval front end, and an admin front end. One of the
functions of the admin FE will be to use the "Questions Selection Form"
and Enter/Select the questions that will be displayed on the eval FE
automatically when it is opened...

In the BE 2 of the tables are Question_List and Questions.
Questions_List (QL) is mainly one field for all questions, Questions
(Q) has 25 question fields per record. The admin user selects
questions from the QL table and assigns a question to each field in the
Q table OR Enters a new Question which is saved as a new record into QL
and fills a field in Q.

In the Eval FE I have a form based on a query with both QL and Q
NON-Related. There is an Unbound field for each Question, which should
be populated by the Q table.

SELECT [tbl_Questions]![Q1] AS Q_1
FROM tbl_Questions
WHERE (((tbl_Questions.Q_ID)=1));

I have used this line in a query and it works, but when I try the same
thing in the unbound field I get the FAMOUS "?NAME"
I've also tried using that line in the query that the Form is based
on... IT works when I run the query... not on the form...

I would appreciate any advice???
Thanks:confused:

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Relevant Pages

  • + Trivantis CourseMill Enterprise Learning Management System - SQL Injection - CVE-20
    ... The username field on the login page is susceptible to SQL injection... ... Trivantis and CourseMill are registered trademarks of Trivantis. ... The logins are unencrypted and stored in the "Admin" table. ... Sample Query Logs from Exploiter Beta: ...
    (Bugtraq)
  • Re: Search sub-form without writing exactly what is contained in query field
    ... will this work if say I type 'Admin' and 'Finance' in the same ... firstly I want to search all staff who have 'finance' ... Is there a way of searching a sub-form (reading from a query) without ... Manager' and 'Finance Manager' appeared as part of the results? ...
    (comp.databases.ms-access)
  • Re: Query that calls value from one table field to another table f
    ... Table Name: Admin ... "Jeff Boyce" wrote: ... I may not use the same definition of the term "populate". ... query is run. ...
    (microsoft.public.access.queries)
  • Re: Queries & table locking
    ... as users do not use the database; it simply serves as a source for ... interprets the current user as admin. ... The query is a make-table query, ... If instead of running a make-table query, ...
    (microsoft.public.access.queries)
  • Re: Link Criteria again
    ... number data type query for just the combo box. ... is an unbound field and places the value of the unbound combo box into the ... Dim stLinkCriteria As String ...
    (microsoft.public.access.formscoding)