Results 1 to 3 of 3
  1. #1
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171

    Linking a table to a form with a button

    I have a form which is used to input a variety of items. Currently, I have embedded in that form an "Activity" table where I log chronologically information that comes in on the separate agreements created by the form. The Activity table is the child which makes the information directly relevant to the specific client being reviewed.

    Instead of having the table appear on the form, I would like to be able to have a button on the form which would open the activity table when needed versus having it ever present on the form. I know the buttons when formatted will allow me to run reports, open forms, run queries, etc. but don't know if I can open a table that way.



    Thanks.

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Yes you can, but it would be better to create a form to enter the data. I would have the form record source be a query, not a table. The button could open the form.
    You should NEVER allow direct data entry into a table.

  3. #3
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171
    Steve, thanks so much. I had the same thought and am trying what you suggested. Here is the problem now ...

    I set up the form in datasheet format, but it doesn't open that way when I put the link to it in my data input form. I do link the fields and can't recall having this problem before, but ...

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

Similar Threads

  1. Linking table value to a text field in a form
    By newbie_204 in forum Access
    Replies: 1
    Last Post: 11-19-2015, 10:08 AM
  2. Linking Information from Table to Form
    By MTSPEER in forum Forms
    Replies: 5
    Last Post: 06-04-2013, 12:04 PM
  3. Button linking back to form?
    By Raygar in forum Reports
    Replies: 1
    Last Post: 05-14-2012, 06:26 PM
  4. CALENDAR on FORM not LINKING to TABLE
    By taimysho0 in forum Forms
    Replies: 5
    Last Post: 01-12-2012, 06:55 PM
  5. Linking button on form to report
    By robertdudley95 in forum Forms
    Replies: 19
    Last Post: 11-09-2011, 12:14 PM

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