Main form is frmEvent and subform is frmMissedEventssub
I tried using Me.Parent!dteentered = Date but that did not work?
Main form is frmEvent and subform is frmMissedEventssub
I tried using Me.Parent!dteentered = Date but that did not work?
Why didn't it work - error message, wrong results, nothing happens? How is that updating main form from subform? Do you mean the code is behind subform - in what event? Why would subform update data in main form?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The data in the subform is generated via a module for missed dates for records in the table for the main form.This data comes from a different table and has to be appended to the table that the main form uses. The main form is being updated via code in the OnClickEvent of a checkbox. The subform has to update the main form because there were times when that record on the main form was not entered and the subform has the list of dates when this was. So even though the main form can have only ONE record, i.e. primary key for each instance, there were times when that record did not get entered. And so more missed dates, more missed check numbers... If the ONLY thing I had to worry about was just the Daily occurrences of that record, then I would only have to filter out whether it was a recurring event or a one time, non-recurring event and enter accordingly, but that is not the case. Anyway, this has nothing to do with the price of cotton in China! Just wrong syntax to get the main form fields updated is all. I tried also Forms!frmEvent.Form![dteentered] = Date and that did not work either.
Child records created before data entry to parent record was completed?
Forms!frmEvent!dteentered = Date
I just tried Me.Parent for the first time and it errors. Don't know how to use it.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Child records were created AFTER record was entered. Record does not get completed until an expiration date is given. I tried that, it did not work, however that field does have a default setting using another field, would this affect the code? MYDte uses EventStart as a default setting and EventStart is a date field.
What do you mean by 'default setting' - Default property? Default property applies only when record first created, means nothing after that.
What is MYDate?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
MyDte is the date used for the final destination which is the check register and it is also used as the date when the transaction is entered. EventStart is the original date.
MyDte has under properties\Data\Default Value =[EventStart]
I have no idea how MyDte pertains to this issue. It was not even mentioned in your original post.
I don't know why the textbox on main form is not populated by subform event. Works for me.
Have you step debugged?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.