Results 1 to 2 of 2
  1. #1
    mgerber94 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    1

    Using a particular cell in a table as the Default Value for a form

    Is there a way to do this? I'm trying to implement the Issue Number of my magazine (the data of which is in a dedicated table), into the subscription form.

  2. #2
    tdecker81 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    23
    Add a yes no field called default. Set this field on the record you want to default to, to yes. Add a filter in the recordsource to filter for default yes now the form will load just this record.

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

Similar Threads

  1. Memo Cell in form and report - autoheight
    By Scorpio11 in forum Access
    Replies: 5
    Last Post: 11-08-2013, 02:12 PM
  2. paste a table into a cell
    By georgenet in forum Import/Export Data
    Replies: 3
    Last Post: 05-20-2011, 01:53 PM
  3. Replies: 1
    Last Post: 11-24-2010, 09:51 AM
  4. Table opening by default
    By rod147 in forum Access
    Replies: 1
    Last Post: 07-07-2009, 10:01 AM
  5. Can we post Access cell data to Excel cell properties?
    By Zethro in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2005, 08:42 AM

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