VERY URGENT: storing date in main form

[Guest]

(see previous thread)

Sorry in advance for re-posting so soon. I really need to sort this out.

When I enter a date into the continuous subform, the date field on the main
form gets updated with the most recent date before the field on the subform
was updated rather than the most recent date after it has been updated (if
that makes sense)

I need to somehow requery or save the record but I can't see how to do it.



ideas?

 

[Jeff Boyce]

You realize, don't you, that the folks here are volunteers? If you have a
very urgent need, perhaps you need to look for paid assistance.

I'm not following your description of what is happening.

I don't see a description of what you want to have happen.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

I have a text field in the header of the subform that gets the most recent
date from the list. I use that to store the date in the main form.

If I change a date from 10/08/2007 to 14/08/2007, the date in the main form
is stored as 10/08/2007. If I change it back to 10/08/2007, the date is
stored as 14/08/2007.

All I want is the most recent date in the date field in the subform (called
"Act_SLA_Date4") to be stored in the date field of the main form (called
"SLA_Date4").

thanks

You realize, don't you, that the folks here are volunteers? If you have a
very urgent need, perhaps you need to look for paid assistance.

I'm not following your description of what is happening.

I don't see a description of what you want to have happen.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

I think I've sorted it out.

Sorry about that. I was getting a bit flustered.

You realize, don't you, that the folks here are volunteers? If you have a
very urgent need, perhaps you need to look for paid assistance.

I'm not following your description of what is happening.

I don't see a description of what you want to have happen.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

I had a eureka moment. I am using the timer in the subform to refresh the
records and then up date the date field in the main form.

It seems to do it.

Apologies once again.

You realize, don't you, that the folks here are volunteers? If you have a
very urgent need, perhaps you need to look for paid assistance.

I'm not following your description of what is happening.

I don't see a description of what you want to have happen.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John W. Vinson]

I had a eureka moment. I am using the timer in the subform to refresh the
records and then up date the date field in the main form.

It seems to do it.

Apologies once again.

Well... I've used timer hacks, but only as a desparation last resort.

I'd suggest instead using the AfterUpdate event of the date textbox. Compare
the entered date to DMax() of the date field, and push the content to the
parent form as needed.

Better: don't store the most recent date in the parent table AT ALL. It's
redundant. Look it up using DMax() or a query instead.

John W. Vinson [MVP]