Results 1 to 4 of 4
  1. #1
    Wendigo is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Feb 2013
    Posts
    4

    2 Forms 1 Table, help!

    Hello guys, this is probably simple but I've search on forum and did a google search and didn't find what I was looking for. (or maybe didn't understand it)

    I've a main form (registos) for my main table (registos)
    and I've put a option box that when is clicked a new form will open (Observações Pendente).
    In this form I want to fill one field (obs_pendente) of the main table.
    I can write on it but when I close it it adds a new registry.

    I can figure it out, maybe is simple but I', just not getting there.
    Any help please?
    Sorry for the bad english and thanks in advance.

    below I leave the image (with the forms and the code)

    Click image for larger version. 

Name:	1.jpg 
Views:	8 
Size:	87.9 KB 
ID:	11196
    Attached Thumbnails Attached Thumbnails 1.jpg  

  2. #2
    alcapps is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    292
    is the new form used to save the value?
    you should open that form and use openargs to pass the data from the main form to the opened form. Try to make the called form unbound.
    on close you can move the changes if that form is dirty or changed back to the main form before it finishes it closing.

    Hope this helps

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    FYI: Unbound Forms do not get Dirty. Just thought you'd like to know.

  4. #4
    Wendigo is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Feb 2013
    Posts
    4
    Alcapps, thanks for the PM, worked great.
    Many thanks.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-01-2012, 03:53 PM
  2. Linking forms to table
    By jdvd in forum Forms
    Replies: 1
    Last Post: 12-11-2011, 06:20 PM
  3. Two Forms to One Table
    By cwild in forum Forms
    Replies: 2
    Last Post: 02-10-2011, 12:31 PM
  4. Table Design w/ forms
    By DrossZro in forum Database Design
    Replies: 9
    Last Post: 09-07-2010, 09:35 AM
  5. Table values in forms
    By xzxz in forum Access
    Replies: 3
    Last Post: 10-28-2008, 08:29 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