Results 1 to 8 of 8
  1. #1
    ukmale65000 is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    31

    Noob question about forms

    I currently have 3 forms and they all work fine, except 1 problem. If i enter data in form 1 and save it using a button and macro that basically says save record then clear form it does save it as record 1. If i then enter a record on form 2 and use the same save method, it does save the record but again as record 1 and overwrites the form 1 record. I cannot for the life of me remember how to solve this issue (its been 15 years since i learned basic access). Can anyone help please?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Record are kept in tables and forms can be bound to these tables.
    After you have entered data into the controls on a form which is bound to a table you need only to close the form or move to a new record on the form to save the entered data. The new form will then be available to enter data into the second record.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    ... and save it using a button and macro that basically says save record
    Whats the code?

  4. #4
    ukmale65000 is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    31
    Thanks for the prompt reply Bob, is there anyway to look at my database to see where i have gone wrong? e.g. attaching it somehow? Im not looking for anyone to do the work as i wont learn but an expert may see a silly mistake ive made

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    We need some context in order to offer any focused advice. Tell us more about your
    -application (in simple , plain English - no database jargon), and
    -tables.

    As Bob advised, you do NOT need a button to save a record. Simply moving to another record will cause current record to be saved.
    Good luck.

  6. #6
    ukmale65000 is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    31
    Ok as plain as i can
    I am trying to save the results of battles within a game. I have 1 form to save tier 6 battle results, 1 form to save tier 8 results and 1 form to save tier 10 results.If i enter a tier 6 game result it saves it to record 1, if i then enter a tier 8 game result it overwrites the tier 6 result as record one. What im trying to achieve is being able to enter a tier result and then if i open a form to enter a result from a different tier it automatically saves it as record 2 , 3 etc etc.
    Thanks for all the help so far i appreciate it

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    And your table(s)?

    Sounds like you have/need a results table
    -battle (name/date/location...)
    -opposing armies/teams
    -tier/level?
    -winner (and details)??

  8. #8
    ukmale65000 is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Oct 2013
    Posts
    31
    Hi orange i have a results table as you described, i think ive cracked the problem

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

Similar Threads

  1. Replies: 2
    Last Post: 04-05-2016, 08:29 AM
  2. Really daft noob question
    By BaldPlumber in forum Access
    Replies: 3
    Last Post: 10-03-2015, 03:57 AM
  3. Replies: 6
    Last Post: 10-09-2013, 02:08 PM
  4. Please help noob question.
    By Deano in forum Forms
    Replies: 3
    Last Post: 01-24-2011, 12:33 PM
  5. HELP NOOB! Easy question
    By SigmaBlu in forum Queries
    Replies: 1
    Last Post: 10-10-2009, 11:23 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