• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

How can I edit a record from a sub-form?

I downloaded a sample database for reoccurring dates. The database was found on http://allenbrowne.com/AppRecur.html . When I click Edit in the sub-form to enter a comment the date value goes blank in the sub form when I click OK.  I have been trying to figure this out but have failed.  recur.accdb
0
seanlhall
Asked:
seanlhall
  • 4
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
If you look closely at the pop-up form, the date disappears because it presumes you will be "Rescheduling" the event.
(Note that the caption of the pop-up form is "Manage an *Exception* to a recurring event")

If you select (or enter) a day in the "Reschedule to" box, the date then appears on the main form.

If you select "Cancel" or "Delete this entry", the original date remains.

This appears to be the way the form is designed to work.
But perhaps your first call should have been to the author of the code:
allen@allenbrowne.com

I don't pretend to know all the intimate details of how another developer complex application was intended to work.
So if your question here is how to simply "Edit" an existing event's "Comment", then it appears that you must select/enter the same date in the "Re-schedule to" box as was the original value.

JeffCoachman




JeffCoachman
0
 
seanlhallAuthor Commented:
Ok I see I would have to put the date in myself if Im jsut entering a comment. Do you se a way I could have the original date on the subform populate in the exception form date when I clcik edit?  Also I did email the author as well. Thanks for taking a look.
0
 
Jeffrey CoachmanMIS LiasonCommented:
I really don't want to modify code in a "Publicly downloadable DB"written by another developer of the caliber of Allen Browne.

Besides, I tried passing the existing date to the pop-up but that did not work.

I would rather you get this resolved by the author.

I'm sure you understand...

JeffCoachman
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
seanlhallAuthor Commented:
ok I understand. Thanks for your help.
0
 
Jeffrey CoachmanMIS LiasonCommented:
The issue is that there are lots of instances where people will copy a DB by a well known author (Allen Browne, Ken Getz, Stephen Lebans, ...et al) and claim it as their own.

Other times someone will modify the db then repost it as "The Original"

Besides, I might modify the code to do as you request, but the modification may have unexpected implications in another aspect of the DB.

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now