Results 1 to 2 of 2
  1. #1
    YaseenIskaf is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    14

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,618
    Paul gave you an answer.

    Another method:
    You would need to use VBA to:
    1) open the query
    2) get the record count
    3) Push the value into the text box control
    4) close the query
    5) Repeat as necessary (4 more times)
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. how to give a code for save and refresh
    By venu_resoju in forum Forms
    Replies: 7
    Last Post: 04-03-2013, 12:29 PM
  2. Query to give Subtotals of field
    By dinesh_ltjd in forum Access
    Replies: 2
    Last Post: 01-12-2013, 01:18 PM
  3. DB will not give Unique ID's
    By DICKBUTTONS in forum Access
    Replies: 1
    Last Post: 02-07-2012, 02:12 PM
  4. Should I give Up on This Form?
    By Palomino33 in forum Forms
    Replies: 25
    Last Post: 11-09-2011, 05:37 AM
  5. Replies: 3
    Last Post: 10-13-2011, 08:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums