Transfering value from one form to another form.

[pedie]

Hi everyone! i thought this should be simple but cant make it work. I have 2 forms, one is calendar and the others is form called updatefr...when date is selected i want it to be transfer to 2 form.

Thanks

[/FONT]
[FONT=Courier New]DoCmd.Close
DoCmd.OpenForm "UpdateFr", acNormal[/FONT]
[FONT=Courier New]Forms![UpdateFr].[Text3].Value = Forms![mYCalendar].[Mydate].Value

 

[psycoperl]

What form is this code on?

It looks like you are closing the form prior to updating the form.

 

[pedie]

Hi, the code is in the first [calender] form

 

[Marbles]

Allen Browne has the best Calendar. And the best advice on how to use it:

http://allenbrowne.com/ser-51.html

 

[Norie]

Pedie

psycoperl has a very good point.

If this code is in the calendar form then that form is getting closed.

Then you try and refer to it again to put the date in the other form.

Try this, it closes the form after the date has been put in the other form.

DoCmd.OpenForm "UpdateFr", acNormal
Forms![UpdateFr].[Text3].Value = Forms![mYCalendar].[Mydate].Value
DoCmd.Close

 

[pedie]

Thanks Norie...
Works now with small edit.

[/FONT]
[FONT=Courier New]DoCmd.OpenForm "UpdateFr", acNormal
Forms![UpdateFr].[Text3].Value = Forms![mYCalendar].[Mydate].Value
DoCmd.Close acForm, "MyCalendar"[/FONT]
[FONT=Courier New]