A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Fresh data from subform to main form



 
 
Thread Tools Display Modes
  #1  
Old December 8th, 2006, 06:45 PM posted to microsoft.public.access.forms
Sandy
external usenet poster
 
Posts: 924
Default Fresh data from subform to main form

I have a main form (05 Registrations form) and a subform (05b Registrations)
that pops up to allow you to register a child for a class. Works fine. I
want this info that is entered into the subform to update/refresh the main
form when I click the exit button. The way it is now, I have to close the
subform, close the main form and reopen and it is there.....I've been reading
all day and I can't figure it out. What do I put where to make this
happen??? Thanks in advance!
  #2  
Old December 8th, 2006, 07:15 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Fresh data from subform to main form

Why do you have to refresh the main form? That should not be necessary.
Since the form and subform have different record sources, changes to data in
the sub form rarely affect data in the main form. What does the Exit button
do?
I will be happy to help, I just want to be sure we are doing the right thing.



"Sandy" wrote:

I have a main form (05 Registrations form) and a subform (05b Registrations)
that pops up to allow you to register a child for a class. Works fine. I
want this info that is entered into the subform to update/refresh the main
form when I click the exit button. The way it is now, I have to close the
subform, close the main form and reopen and it is there.....I've been reading
all day and I can't figure it out. What do I put where to make this
happen??? Thanks in advance!

  #3  
Old December 8th, 2006, 07:48 PM posted to microsoft.public.access.forms
Sandy
external usenet poster
 
Posts: 924
Default Fresh data from subform to main form

I'm sorry, let me rephrase. On the main form, I have a list of classes the
kids are currently registered to. On the popup form (not a subform) it
allows me to register them for another class. When I close the popup form
(the main form is still open), I want to see the new classes I just
registered them for without exiting and reopening this main form. Sorry for
the confusion. Maybe I have it set up incorrectly?

"Klatuu" wrote:

Why do you have to refresh the main form? That should not be necessary.
Since the form and subform have different record sources, changes to data in
the sub form rarely affect data in the main form. What does the Exit button
do?
I will be happy to help, I just want to be sure we are doing the right thing.



"Sandy" wrote:

I have a main form (05 Registrations form) and a subform (05b Registrations)
that pops up to allow you to register a child for a class. Works fine. I
want this info that is entered into the subform to update/refresh the main
form when I click the exit button. The way it is now, I have to close the
subform, close the main form and reopen and it is there.....I've been reading
all day and I can't figure it out. What do I put where to make this
happen??? Thanks in advance!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.