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

    Dynamic Default Value


    Hello all, I am Access begineer and I have searched this site and others for an answer to something that should be a simple problem. Here is the situation, I have several tables but lets focus on two Table1 and Table2

    Table1.ID is a foriegn key in Table2.NewID

    I want the default value for Table2.NewID to be the MAX of Table1.ID; that is I want Table2.NewID to auto default/select whatever is the highest ID of Table1.ID.

    I have toyed with this as much as I can by entering different SQL statements in the the default field of the datasheet. And by defining different Macros for OnFocus event.I would greatly appreciate any and all help.

    Access 2007 running on Windows 7 64bit

  2. #2
    Estuardo's Avatar
    Estuardo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Portugal
    Posts
    22
    G'd evening,
    I don't think you can do that at table level, but you can do it easily with code at form level.
    G'd luck

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

Similar Threads

  1. Dynamic Form, Dynamic labels/ captions?
    By JFo in forum Programming
    Replies: 15
    Last Post: 10-12-2011, 08:33 PM
  2. Dynamic Emailing
    By EliOklesh in forum Forms
    Replies: 3
    Last Post: 08-25-2011, 08:51 PM
  3. Dynamic Web page
    By KevinH in forum Access
    Replies: 3
    Last Post: 01-03-2010, 06:56 PM
  4. Dynamic Report
    By vCallNSPF in forum Reports
    Replies: 0
    Last Post: 12-08-2009, 04:19 PM
  5. Dynamic Query
    By pushpm in forum Queries
    Replies: 0
    Last Post: 04-22-2009, 12:58 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