Results 1 to 2 of 2
  1. #1
    cindyaquino is offline Novice
    Windows Vista Access 2000
    Join Date
    Mar 2012
    Posts
    1

    How to retrieve data from a table and put it into a form field?

    Hi,

    I have a table:
    Click image for larger version. 

Name:	2.JPG 
Views:	11 
Size:	32.4 KB 
ID:	6702


    And I want to extract the "Submit Date" data and place them into their corresponding fields on a form:
    Click image for larger version. 

Name:	1.JPG 
Views:	11 
Size:	25.6 KB 
ID:	6703

    Basically I want to take the Submit Date column from the table and place them (in the same order) in the form. How can I do so? I'm also confused as to what to select for the Control Source in the Form Design.

    Thanks!

    *Note: both "Submit Date" columns in the form and table are set to Date/Time.

    [Just started using Access a few weeks ago. Sorry!]

    --Using Access 2000

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    That second image is of a form? How did you get the categories and DueDate values to show? Are they labels? What table is the form bound to? What is it you are really trying to do? Do you want to provide project for analysis? Attach to post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 10-30-2013, 11:42 AM
  2. Changing the data source for a table field with a form
    By WildcatMatt92 in forum Database Design
    Replies: 3
    Last Post: 11-30-2011, 03:16 PM
  3. Replies: 1
    Last Post: 05-17-2011, 05:19 AM
  4. How to retrieve field names in a table
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 12-05-2010, 09:09 PM
  5. Retrieve Data Too Slow
    By BGF in forum Programming
    Replies: 8
    Last Post: 09-08-2010, 04:28 PM

Tags for this Thread

Posting Permissions

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