Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010
    Posts
    3

    Unanswered: Field not from control source

    I have a form with a control source that is a table

    I want one of my fields in that form to get data from a query I made instead, how would I do this ?

    I get #Name? when I use =Q_Sort!Years
    Last edited by Ali93; 03-13-10 at 00:02.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Either you can create a query in which the field is included and use this query as a recordsource for the form, or you can adjust the value of the control in the Current event of the form (using DLookup for instance).

    You can also use a control that would accept a recordsource, such as a combo or a listbox.
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •