Professional Web Applications Themes

update data on form - Microsoft Access

Hello, I have a form A that shows different data. If I want to change data I open a form B by clicking a button. When I close form B, I don't get to see the changes I made. I tried the DoCmd.Refresh with several events (Before Update, On Got Focus, ...) but nothing works. What am I doing wrong? Thanks for any help. Chris...

  1. #1

    Default update data on form

    Hello,

    I have a form A that shows different data. If I want to change data I open a
    form B by clicking a button. When I close form B, I don't get to see the
    changes I made. I tried the DoCmd.Refresh with several events (Before
    Update, On Got Focus, ...) but nothing works. What am I doing wrong?

    Thanks for any help.

    Chris


    Chris Guest

  2. #2

    Default Re: update data on form

    Hi,
    Try :
    Forms!formA.Requery
    in the close event of form B

    --
    HTH
    Dan Artuso, Access MVP


    "Chris" <cclaespandora.be> wrote in message news:8ADUa.34763$F92.3760afrodite.telenet-ops.be...
    > Hello,
    >
    > I have a form A that shows different data. If I want to change data I open a
    > form B by clicking a button. When I close form B, I don't get to see the
    > changes I made. I tried the DoCmd.Refresh with several events (Before
    > Update, On Got Focus, ...) but nothing works. What am I doing wrong?
    >
    > Thanks for any help.
    >
    > Chris
    >
    >

    Dan Artuso Guest

  3. #3

    Default update data on form

    >-----Original Message-----
    >Hello,
    >
    >I have a form A that shows different data. If I want to
    change data I open a
    >form B by clicking a button. When I close form B, I don't
    get to see the
    >changes I made. I tried the DoCmd.Refresh with several
    events (Before
    >Update, On Got Focus, ...) but nothing works. What am I
    doing wrong?
    >
    >Thanks for any help.
    >
    >Chris
    >
    >
    >.
    >
    You have to refresh the control! Like cboResults.requery
    not the form itself
    henri Guest

  4. #4

    Default Re: update data on form

    Dan,
    I think the problem is a bit more complex. In fact I have two forms (A and
    B) that both contain a subform. On form A I choose by means of a combobox
    the records that need to appear in the subform (combobox contains list of
    product numbers, subform shows composition of product on continuous form).
    Now I would like by clicking a button to open form B so I can make changes
    in the composition. Form B also contains a combobox with the product numbers
    (because I'm using it also seperately) and a continuous subform for the
    articles. After closing form B I would like to see the changes I made in
    form A.
    Is there a way to do this and also avoiding to have to use the combobox each
    time I change forms.
    When trying to explain this I noticed that there's something odd happening
    with the sorting in the subforms. When I make a change in the composition in
    form B the order of the articles has changed when I open form A. When I
    close form A and open form B again, I also get the changed order there. What
    is happening here???

    Thanks in advance for any help with this.

    Chris

    "Dan Artuso" <dartusoNoSpampagepearls.com> schreef in bericht
    news:OhLTVk8UDHA.1956TK2MSFTNGP10.phx.gbl...
    > Hi,
    > Try :
    > Forms!formA.Requery
    > in the close event of form B
    >
    > --
    > HTH
    > Dan Artuso, Access MVP
    >
    >
    > "Chris" <cclaespandora.be> wrote in message
    news:8ADUa.34763$F92.3760afrodite.telenet-ops.be...
    > > Hello,
    > >
    > > I have a form A that shows different data. If I want to change data I
    open a
    > > form B by clicking a button. When I close form B, I don't get to see the
    > > changes I made. I tried the DoCmd.Refresh with several events (Before
    > > Update, On Got Focus, ...) but nothing works. What am I doing wrong?
    > >
    > > Thanks for any help.
    > >
    > > Chris
    > >
    > >
    >
    >

    Chris Guest

Similar Threads

  1. Autopopulated form not displaying data in pdfunless the form field is clicked
    By shannon_coleman@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 4
    Last Post: August 27th, 09:21 PM
  2. file upload form enctype="multipart/form-data
    By kbuska525 in forum Macromedia ColdFusion
    Replies: 2
    Last Post: June 27th, 04:52 AM
  3. Getting client file name from a submitted form usingmultipart/form-data
    By restlessmedia in forum Macromedia ColdFusion
    Replies: 1
    Last Post: June 7th, 01:28 PM
  4. Creating an update data form
    By Black People Online in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: May 11th, 11:38 PM
  5. Replies: 1
    Last Post: February 22nd, 12:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139