Results 1 to 2 of 2

Thread: Append Query

  1. #1
    Join Date
    Aug 2002
    Location
    Arkansas
    Posts
    13

    Unanswered: Append Query

    How do you get an append query to reference a field from a loaded form?

    [FORMS]![formname]![txtbox]

    I also tried to use this in the criteria section with the same problem.

    Using global variables is the only way I have got this to work.

    Thx

    Tag

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Here is an example:

    Select * From tblCustomers Where CustomerID = Forms("frmCustomer").txtCustomerID

    Igor

Posting Permissions

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