update cascading forms
in [Forms]
|
From: OD on 10 May 2010 09:15 Thanks Doug But in my case here, this didn't work. Not sure what I'm doing wrong here. When I run a trace it calls the open form but if I have a breakpoint after the openform on the refresh - it skips over all the calls in the 2nd form after it opens which doesn't make sense "Douglas J. Steele" wrote: > How are you opening Form 2? > > If you're opening it as a dialog form from Form 1, that means execution of > code in Form 1 halts until Form 2 is closed, so you can simply put the > requery as the next line of code. > > If you're not opening it as a dialog form, try putting the Requery into the > GotFocus event of Form 1, or have Form 2 requery Form 1 as it's closing. > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/DJSteele > (no e-mails, please!) > > "OD" <OD(a)discussions.microsoft.com> wrote in message > news:34713098-A529-4B60-A01E-A37A4D018F5C(a)microsoft.com... > > Hi > > > > This has probably been asked a number of times but I couldn't find a > > resolution for my issue. I have a form that calls a second form. Form 1 > > displays the client information (name, address, phone) in view only. The > > 2nd > > form allows the client to change the information. The information updates > > correctly to the database but I can't get the orginal form to show the > > updated information without closing out and going back in. I know I need > > to > > requery or do a find = but can't figure out which event this should go in. > > There's no real code I can post as I don't know what or where to do this. > > Any > > help is appreciated > > Thanks > > > . >
From: OD on 10 May 2010 09:16 I agree - it should but it didn't. Not sure what's going on here right now. been stuck on this for quite a while now "RonaldoOneNil" wrote: > Forms![Form 1 Name].Requery should work > > "OD" wrote: > > > Thank you but that didn't work. This is what I've been up against for a while > > for some reason. This should've worked but... > > > > "RonaldoOneNil" wrote: > > > > > In the On Close event of your 2nd form put this code using your own form 1's > > > name. > > > > > > Forms![Form 1 Name].Refresh > > > > > > "OD" wrote: > > > > > > > Hi > > > > > > > > This has probably been asked a number of times but I couldn't find a > > > > resolution for my issue. I have a form that calls a second form. Form 1 > > > > displays the client information (name, address, phone) in view only. The 2nd > > > > form allows the client to change the information. The information updates > > > > correctly to the database but I can't get the orginal form to show the > > > > updated information without closing out and going back in. I know I need to > > > > requery or do a find = but can't figure out which event this should go in. > > > > There's no real code I can post as I don't know what or where to do this. Any > > > > help is appreciated > > > > Thanks
From: Douglas J. Steele on 10 May 2010 09:51 Not sure I understand what you're saying. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "OD" <OD(a)discussions.microsoft.com> wrote in message news:124B8DE2-8838-4AB2-B268-9D12EA105110(a)microsoft.com... > Thanks Doug > But in my case here, this didn't work. Not sure what I'm doing wrong here. > When I run a trace it calls the open form but if I have a breakpoint after > the openform on the refresh - it skips over all the calls in the 2nd form > after it opens which doesn't make sense > > "Douglas J. Steele" wrote: > >> How are you opening Form 2? >> >> If you're opening it as a dialog form from Form 1, that means execution >> of >> code in Form 1 halts until Form 2 is closed, so you can simply put the >> requery as the next line of code. >> >> If you're not opening it as a dialog form, try putting the Requery into >> the >> GotFocus event of Form 1, or have Form 2 requery Form 1 as it's closing. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://www.AccessMVP.com/DJSteele >> (no e-mails, please!) >> >> "OD" <OD(a)discussions.microsoft.com> wrote in message >> news:34713098-A529-4B60-A01E-A37A4D018F5C(a)microsoft.com... >> > Hi >> > >> > This has probably been asked a number of times but I couldn't find a >> > resolution for my issue. I have a form that calls a second form. Form 1 >> > displays the client information (name, address, phone) in view only. >> > The >> > 2nd >> > form allows the client to change the information. The information >> > updates >> > correctly to the database but I can't get the orginal form to show the >> > updated information without closing out and going back in. I know I >> > need >> > to >> > requery or do a find = but can't figure out which event this should go >> > in. >> > There's no real code I can post as I don't know what or where to do >> > this. >> > Any >> > help is appreciated >> > Thanks >> >> >> . >>
From: OD on 11 May 2010 09:56 Thanks Doug, Yeah, it's confusing and I think I brought it on myself. Just can't figure out how to dig myself out. I put a breakpoint in after the call to open the next form and the program went to the next line in the current form and didn't open the next form. The next form is an unbound which I do an update query to modify the record but since I'm technically not closing or leaving the prior form there's no "activate", "Focus" or anything like that. I'm playing with closing the forms as I call the next one and then reopening but this is giving me issues doing that too. Like I said, probably brounght on by how I imagined doing this. Thanks "Douglas J. Steele" wrote: > Not sure I understand what you're saying. > > -- > Doug Steele, Microsoft Access MVP > http://www.AccessMVP.com/DJSteele > (no e-mails, please!) > > "OD" <OD(a)discussions.microsoft.com> wrote in message > news:124B8DE2-8838-4AB2-B268-9D12EA105110(a)microsoft.com... > > Thanks Doug > > But in my case here, this didn't work. Not sure what I'm doing wrong here. > > When I run a trace it calls the open form but if I have a breakpoint after > > the openform on the refresh - it skips over all the calls in the 2nd form > > after it opens which doesn't make sense > > > > "Douglas J. Steele" wrote: > > > >> How are you opening Form 2? > >> > >> If you're opening it as a dialog form from Form 1, that means execution > >> of > >> code in Form 1 halts until Form 2 is closed, so you can simply put the > >> requery as the next line of code. > >> > >> If you're not opening it as a dialog form, try putting the Requery into > >> the > >> GotFocus event of Form 1, or have Form 2 requery Form 1 as it's closing. > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://www.AccessMVP.com/DJSteele > >> (no e-mails, please!) > >> > >> "OD" <OD(a)discussions.microsoft.com> wrote in message > >> news:34713098-A529-4B60-A01E-A37A4D018F5C(a)microsoft.com... > >> > Hi > >> > > >> > This has probably been asked a number of times but I couldn't find a > >> > resolution for my issue. I have a form that calls a second form. Form 1 > >> > displays the client information (name, address, phone) in view only. > >> > The > >> > 2nd > >> > form allows the client to change the information. The information > >> > updates > >> > correctly to the database but I can't get the orginal form to show the > >> > updated information without closing out and going back in. I know I > >> > need > >> > to > >> > requery or do a find = but can't figure out which event this should go > >> > in. > >> > There's no real code I can post as I don't know what or where to do > >> > this. > >> > Any > >> > help is appreciated > >> > Thanks > >> > >> > >> . > >> > > > . >
From: BruceM via AccessMonster.com on 11 May 2010 10:04 It would help to see the code you are using. Please describe where the break point is placed, and what happens (or doesn't) as you step through the code. OD wrote: >Thanks Doug, > >Yeah, it's confusing and I think I brought it on myself. Just can't figure >out how to dig myself out. I put a breakpoint in after the call to open the >next form and the program went to the next line in the current form and >didn't open the next form. The next form is an unbound which I do an update >query to modify the record but since I'm technically not closing or leaving >the prior form there's no "activate", "Focus" or anything like that. I'm >playing with closing the forms as I call the next one and then reopening but >this is giving me issues doing that too. >Like I said, probably brounght on by how I imagined doing this. > >Thanks > >> Not sure I understand what you're saying. >> >[quoted text clipped - 39 lines] >> >> . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: Problem in a query with DLookUp Next: Baffled by missing data on printout |