Hi, I have two forms. School and Pa

[mk2lee1]

Hi, I have two forms. School and Participation.
Within school form, there is field called note. I would like to put this note both in school and Participation form. However, I would like note in Participation form to change automatically when I change the school form (for instance, from schoolA to schoolB) So note in Participation form to reflect the same note that is in School Form. Any idea? thanks~

 

[bsagal]

Go to the participation form, click on the properties of the note that you have placed there.

Under control source, type this in

=forms![School form]![name of object on school form]

replace:

School form with the name of your school form

name of object on school form with the name of the note control on the school form


That should work.

 

[mk2lee1]

It kinda worked. But I can't edit in the note (a text box) from participation form so that when I edit there, it will be automatically saved so it is same when I open it up again in school form.

 

[Rmck87]

What if you set the afterupdate event for 'note' to save the value of 'note'. that way when you access 'note' your accessing the already saved value?

And some things, that should not have been forgotten, were lost.

 

[mk2lee1]

How can I do that? I kinda do not know how to proceed in what rmck87 have mentioned above? sorry...

 

[Rmck87]

ok, well, i think i might understand you i might be mistaken. But, what is note? Can you tell me that, then i might be able to explain a little better.

And some things, that should not have been forgotten, were lost.

 

[mk2lee1]

ok..
currently, I have two forms. School and Participation.
Within school form, I have textfield called note (that is connected to table.field called School.Note) And In here I could be able to change the values.
Let say there is two school. School A and B. And Of course these two schools have its own disticnt "note" When I click command button that opens Participation form, all the values changes according to whether its school A or School B in School Form.
What I would like to put is the same "note" from Form.School. so that when I click the command button from School form, and opens Participation form, my "note" in Participation to be same as the note from school form, with editable functions. So when I edit "note" in participation form, it will save to the table.field, School.Note, as well, like the "note" in school form.

What I have right now in form participation is a , textfield with the default value set to "=forms!school!note." This solved the problem of my first question, how to open the form participation.note, so that it reflects the school form (whether it is school A or School B's note) But its doesn't save the value that I write in, thus my second question is still unsolved.

Can you help me on this? sorry...

 

[Rmck87]

Ummm what if you created a textbox in your school form. Then you could type in values in it (for 'note'), and after you typed a value('note') you would resave the values of 'note' and that way you could go open form 'participation' and it would be opened as it was saved. Do you understand what im saying, i kind of do, but i think i might be confusing myself along with you. So, what im basically saying is to create a textbox in the school form so you could put values in it for 'note'.

And some things, that should not have been forgotten, were lost.

 

[mk2lee1]

actually that is what i have done already... and what i would like to do is put second note in participation.. that is practically same "note" as in school form...

 

[bsagal]

mk2lee1,

What if you just connected both text boxes to School.Note, that way both of them would display the same thing and they would both be updatable.

 

[mk2lee1]

in where? should i connect it? I am kinda new to this.. so it might be much a help if you can elaborte that for me.. sorry...

 

[bsagal]

Try this.

Lets say the text box in your 2nd form is called note2.

Click on the properties of note 2, go to the all tab, and scroll down untill you see the after update section.

Click on it, and click on the 3 dots (...)

Go to code builder, and when it comes up type this

forms![first form]!note1.value=note2.value

where first form is the name of the first form
note1 is the name of the text box on the first form
note2 is the name of the text box on the 2nd form

That should work.

 

[mk2lee1]

ok it did changed.. thank you so much.. but the table where its orginally changed, will only change when I close or click other parts of the first form.. after update is taken. Is there code where i could change table as well.. from the second note? thank you..

 

[bsagal]

Does the table need to be updated right away?

If it does, just off the top of my head you can add this line under the last thing i told you to write.

forms![first form]!note1.setfocus

and under that

forms![second form]!note2.setfocus



that while bring the focus to the first form, which will simulate a click on that form, and then it will simulate a click back on your 2nd form, all that should happen really fast.

Hope that helps

 

[mk2lee1]

thank you very much.. i think i have finally solved this problem..

 

[Rmck87]

Sorry i didnt respond my internet was temporarily down, but thats exactly where i was going, and it looks like you guys got it figured out.

And some things, that should not have been forgotten, were lost.

 

[mk2lee1]

thanks to you too.. rmck87.. its been great help both of you guys~~