Never mind, I re-read the original post and Tom's response, and all became much clearer.
Thanks, Toby ----- Original Message ----- From: "Toby Bierly" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Wednesday, October 05, 2005 11:10 AM Subject: Re: [AccessDevelopers] Re: How to update a open form > I'm sorry if I am confused, but what is your question? > > Thanks, > Toby > > ----- Original Message ----- > From: "Richard" <[EMAIL PROTECTED]> > To: <AccessDevelopers@yahoogroups.com> > Sent: Wednesday, October 05, 2005 5:16 AM > Subject: [AccessDevelopers] Re: How to update a open form > > > > I am updating the form with information that I place in the table > > from the sub-form that is open. I am doing a call re-allocation > > program. Main form and subform 1 have the orginal call volume for a > > agent. This form is for agents that are absent and the cals on their > > routes need to be re-allocated to another agent. The sub form has > > drop down menus from a table that has all the agents that are under > > 140 calls for the day. I want the 2nd form to to display the route > > (s) of the agents and the toal cals so that they are not allocated > > more than 160 calls for the day. > > > > --- In AccessDevelopers@yahoogroups.com, "Tom Oakes" <[EMAIL PROTECTED]> > > wrote: > > > You can set values on other forms by simply referring to the > > control on the > > > other form. > > > For example, in the AfterUpdate of the FirstName field of > > the "entry" form, > > > put code that looks something like this: > > > > > > Forms!frmOtherForm!txtFirstname = Me.FirstName > > > > > > It probably makes sense, however, to examine why you're doing this > > and > > > determine whether there's a better course of action. I would only > > do this > > > if form #2 were utilitarian in nature and I simply needed to > > transfer the > > > value for display purposes. If form #2 is bound, there are likely > > better > > > routes to take. > > > > > > What is the nature of the two forms and why are you wanting to > > update #2 > > > from #1? > > > > > > Tom Oakes > > > Personal PC Consultants, Inc. > > > [EMAIL PROTECTED] > > > 503.230.0911 (O) > > > 402.968.6946 (C) > > > 734.264.0911 (F) > > > > > > > > > > > > > > > _____ > > > > > > From: AccessDevelopers@yahoogroups.com > > > [mailto:[EMAIL PROTECTED] On Behalf Of Richard > > > Sent: Tuesday, October 04, 2005 12:08 PM > > > To: AccessDevelopers@yahoogroups.com > > > Subject: [AccessDevelopers] How to update a open form > > > > > > > > > I want to be able to update a form that is open based on entry that > > I > > > am entering into another subform. When I change the data on the > > main > > > form, IE..Employee I would like for the 2nd form (not the sub form) > > to > > > change also. Is that possible? > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > > > > > > > > > > > > SPONSORED LINKS > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+developer&w1=Microsoft > > > > > +access+developer&w2=Microsoft+access+help&w3=Microsoft+access+databas > > e&w4=M > > > > > icrosoft+access+training&w5=Microsoft+access+training+course&w6=Micros > > oft+ac > > > cess+programming&c=6&s=193&.sig=d-CjBIrYOH9NCKHYFeGZJA> access > > developer > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+help&w1=Microsoft+acce > > > > > ss+developer&w2=Microsoft+access+help&w3=Microsoft+access+database&w4= > > Micros > > > > > oft+access+training&w5=Microsoft+access+training+course&w6=Microsoft+a > > ccess+ > > > programming&c=6&s=193&.sig=crx-d4AAhdklv_VozGVAUw> access help > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+database&w1=Microsoft+ > > > > > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database > > &w4=Mi > > > > > crosoft+access+training&w5=Microsoft+access+training+course&w6=Microso > > ft+acc > > > ess+programming&c=6&s=193&.sig=qg2hDuQNweByMCX0NU7cEA> access > > database > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+training&w1=Microsoft+ > > > > > access+developer&w2=Microsoft+access+help&w3=Microsoft+access+database > > &w4=Mi > > > > > crosoft+access+training&w5=Microsoft+access+training+course&w6=Microso > > ft+acc > > > ess+programming&c=6&s=193&.sig=bLZHqTqWUQny609X1OkmNA> access > > training > > > Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+training+course&w1=Mic > > > > > rosoft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+d > > atabas > > > > > e&w4=Microsoft+access+training&w5=Microsoft+access+training+course&w6= > > Micros > > > oft+access+programming&c=6&s=193&.sig=d8GQXfQW3RZ64rOfzIMo8A> access > > > training course Microsoft > > > <http://groups.yahoo.com/gads? > > t=ms&k=Microsoft+access+programming&w1=Microso > > > > > ft+access+developer&w2=Microsoft+access+help&w3=Microsoft+access+datab > > ase&w4 > > > > > =Microsoft+access+training&w5=Microsoft+access+training+course&w6=Micr > > osoft+ > > > access+programming&c=6&s=193&.sig=iXDlL79-kkgjv6fLyFu3Sg> access > > programming > > > > > > > > > _____ > > > > > > YAHOO! GROUPS LINKS > > > > > > > > > > > > * Visit your group "AccessDevelopers > > > <http://groups.yahoo.com/group/AccessDevelopers> " on the web. > > > > > > > > > * To unsubscribe from this group, send an email to: > > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED] > > subject=Unsubscribe> > > > > > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > > Service > > > <http://docs.yahoo.com/info/terms/> . > > > > > > > > > _____ > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
