Board index » VBA

All times are UTC



 updating a field in a form from a subform 
Author Message
Simon Guerti
#1 / 4
 updating a field in a form from a subform

Hi, I want to update a field that is a date in a form.
I want to update it from a subform.
if all the dates are completed in the subform, i want the
global date in my form to be updated. I have tried many,
many ways to do it but it is often only updated when I
close and reopen the form or when I edit a field in the
form and I save it again. It is like if it was only
updating one step after I do It.
If anyone know the good way to do that, please share it
with me :)

Thanks

Simon



Tue, 26 Jul 2005 01:33:30 GMT  
Simon Guerti
#2 / 4
 updating a field in a form from a subform
never mind, problem is solved.
Quote:
>-----Original Message-----
>Hi, I want to update a field that is a date in a form.
>I want to update it from a subform.
>if all the dates are completed in the subform, i want the
>global date in my form to be updated. I have tried many,
>many ways to do it but it is often only updated when I
>close and reopen the form or when I edit a field in the
>form and I save it again. It is like if it was only
>updating one step after I do It.
>If anyone know the good way to do that, please share it
>with me :)

>Thanks

>Simon
>.



Tue, 26 Jul 2005 02:46:21 GMT  
jopi
#3 / 4
 updating a field in a form from a subform
Hello to all,

Mind me asking, but what is the solution ?

Greetings

Johan


Quote:
> never mind, problem is solved.

> >-----Original Message-----
> >Hi, I want to update a field that is a date in a form.
> >I want to update it from a subform.
> >if all the dates are completed in the subform, i want the
> >global date in my form to be updated. I have tried many,
> >many ways to do it but it is often only updated when I
> >close and reopen the form or when I edit a field in the
> >form and I save it again. It is like if it was only
> >updating one step after I do It.
> >If anyone know the good way to do that, please share it
> >with me :)

> >Thanks

> >Simon
> >.



Thu, 28 Jul 2005 21:21:14 GMT  
John Mishefsk
#4 / 4
 updating a field in a form from a subform

Quote:

> Hello to all,

> Mind me asking, but what is the solution ?

 From the subform:

Me.Parent.Form!txtMyDate = Date()

Me says "current form"
.Parent says get the parent form
.Form say treat it like a "Form" object
!txtMyDate says work with the txtMyDate control on this form

and finally assign the current date. (Use =Now() for date and time.)

--
'-------------------------------
' John Mishefske
'-------------------------------



Sat, 30 Jul 2005 11:22:26 GMT  
 
 Page 1 of 1
  [ 4 post ] 

 Relevant Pages 

1. Referencing a field on a SubForm within a Subform

2. Access 97 - Subform access triggers update for Main Form

3. Filter By Form Using Subform Fields

4. Subform linked by autonumber field in main form

5. Want to add record with form when subform field is changed

6. navigating for keyboard users - subfrom to form - subform to subform

7. changing the sourceobject of subform when the form and subform are loaded

8. Form Question - Stepping Through Subform Records on Master Form

9. ComboBox wont update another Field on same Form

10. Updating field in form from summary value in another

11. Updating Form Fields

12. Updating a field on a form

  

 
Powered by phpBB® Forum Software