Results 1 to 7 of 7
  1. #1
    Philw is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    4

    Newbie needs help please

    I am a complete newbie to Access and mostly self taught and am struggling with one particular problem.
    I have created a database that the prime page is a membership database with member personal details – name, address date of birth etc.
    These members are regularly invited to functions and having selected the correct member from the main Members form a click opens the Acceptance form. This form records the function applied for, the menu choice, etc
    The member name is automatically applied to the Acceptance form but it is necessary to select the function from a combo box fin a pop up form the Functions table.
    As there will be many members accepting for the same function I am trying to get the function name to be applied to the field in this form automatically, unless changed by the operator.


    I have tried to do this by getting the field to default to the data recorded for the last (i.e. previous) record and as far as I can ascertain I should use the DMax and DLookup functions but I’m not sure how to! Presumably this would be some code on the Form as a On Open event?.....or am I misunderstanding this completely
    Any guidance would be much appreciated.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If you want to 'carry forward' data input in a record to next record, one method is to set control DefaultValue property using the control's AfterUpdate event:

    Me.controlname.DefaultValue = Me.controlname

    If you want to set value of first record of a data entry session when form opens based on most recent record in table, DMax is often used for this purpose when the field is saving a sequential value otherwise VBA opening a recordset might be needed - but need more info about your db structure.

    If you want to provide db for analysis, follow instructions at bottom of my 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.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    No that much of a Newbie surely?, your first post was in 2014?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    Philw is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    4

    Reply to Welshgasman

    Quote Originally Posted by Welshgasman View Post
    No that much of a Newbie surely?, your first post was in 2014?
    Welshgasman - Yes - Sorry if I misled you but I was just learning Access in 2014 and then changed jobs - haven't used it since. What little knowledge I had has aged by nine years of never even opening Access. That's why I'm struggling a bit.

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Philw,

    Can you show us your tables and relationships? Sample of the form(s) and/or a copy of your evolving database with instructions.

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    This might be helpful.

    PhilW-Membership Scheduling-davegri-v01.zip

    If you need additional fields in the subform pertaining to individual member/event assignments, add them to the junction table.

    Click image for larger version. 

Name:	Members.png 
Views:	36 
Size:	53.7 KB 
ID:	50215
    Last edited by davegri; 05-09-2023 at 09:35 AM. Reason: more info

  7. #7
    Philw is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    4
    Thanks to all for the offers of assistance.
    One expert has been in touch direct and has helped straighten out my confused thinking!

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

Similar Threads

  1. Need your help ....Newbie
    By Accessnewbie008 in forum Import/Export Data
    Replies: 73
    Last Post: 02-15-2017, 05:25 AM
  2. Newbie here!
    By Whatrold in forum General Chat
    Replies: 1
    Last Post: 08-09-2016, 11:02 AM
  3. Newbie needs help
    By Daryl2106 in forum Access
    Replies: 8
    Last Post: 01-24-2012, 09:12 PM
  4. newbie needs help
    By hollyh in forum Queries
    Replies: 1
    Last Post: 08-23-2011, 03:39 PM
  5. I need (newbie) help, please!
    By Over in forum Access
    Replies: 2
    Last Post: 02-05-2011, 10:14 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
  •  
Other Forums: Microsoft Office Forums