Grrr....Is this an Access 2007 thing?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have no problem opening up a 2nd pop-up form that is linked to
another form IF the record from the main form ISN'T new. However when
it is new it NEVER will save the linked record in the 2nd form.

This is what I mean. On the main form if you enter a new record, in
this case a "Person", then click on a command button, it will open up
a second linked form (it filters the 2nd form by it's "PersonID" ). Of
course in this instance the 2nd form will open completely blank since
there are not yet any related records. This 2nd form has the following
code in it's "Before Insert" event.

Me.[PersonID] = Me.OpenArgs

This fills in the "PersonID" on the 2nd form so the two SHOULD be
linked. However as soon as I close the 2nd form, the information IS
NOT SAVED! This ONLY seems to happen if the record on the main form is
NEW. If the record on the main form is a pre-exisitng record, then I
can always open up the 2nd form, and add records, and they are saved.

The only way to prevent this seems to be to actually do a manual SAVE
on the main form after I enter a new record, and then when I click on
the button to open the 2nd form, and enter data, it is always saved. I
tried adding code to the main form that adds a "DoCmd.RunCommand
acCmdSaveRecord" on the "BeforeInsert" event but this doesn't fix the
problem for some ungodly reason...

I don't ever remember this happening in Access 2003. Is this some kind
of bug, or I'm I missing something? Any help is much appreciated.
Thanks!
 
Jeff,
On the button that opens the popup, put this code to save the record before
you open the popup.

If Me.Dirty = True Then
Me.Dirty = False
End If
DoCmd.OpenForm "ThePopupForm"

Jeanette Cunningham
 
The behaviour you describe is exactly what I would expect when you have
referential integrity set between 2 tables: the child record can't be saved
because there isn't a corresponding parent yet. Once you save the parent
record, you can add the child.

If you were able to get this to work before (i.e., create a child record
before the parent), my guess would be that the relationship between the 2
tables has changed (i.e., referential integrity has been added).
 
Jeff,
On the button that opens the popup, put this code to save the record before
you open the popup.

If Me.Dirty = True Then
Me.Dirty = False
End If
DoCmd.OpenForm "ThePopupForm"

Jeanette Cunningham


I have no problem opening up a 2nd pop-up form that is linked to
another form IF the record from the main form ISN'T new. However when
it is new it NEVER will save the linked record in the 2nd form.
Click to expand...
This is what I mean. On the main form if you enter a new record, in
this case a "Person", then click on a command button, it will open up
a second linked form (it filters the 2nd form by it's "PersonID" ). Of
course in this instance the 2nd form will open completely blank since
there are not yet any related records. This 2nd form has the following
code in it's "Before Insert" event.
Click to expand...
Me.[PersonID] = Me.OpenArgs
Click to expand...
This fills in the "PersonID" on the 2nd form so the two SHOULD be
linked. However as soon as I close the 2nd form, the information IS
NOT SAVED! This ONLY seems to happen if the record on the main form is
NEW. If the record on the main form is a pre-exisitng record, then I
can always open up the 2nd form, and add records, and they are saved.
Click to expand...
The only way to prevent this seems to be to actually do a manual SAVE
on the main form after I enter a new record, and then when I click on
the button to open the 2nd form, and enter data, it is always saved. I
tried adding code to the main form that adds a "DoCmd.RunCommand
acCmdSaveRecord" on the "BeforeInsert" event but this doesn't fix the
problem for some ungodly reason...
Click to expand...
I don't ever remember this happening in Access 2003. Is this some kind
of bug, or I'm I missing something? Any help is much appreciated.
Thanks!
Click to expand...
Click to expand...

Thanks Jeanette, that worked.

However I still don't understand why adding a "DoCmd.RunCommand
acCmdSaveRecord" on the "BeforeInsert" of the main form doesn't do the
same thing. Can you not do the equivalent of hitting the "Save" button
with this command, so the record is saved after the key field on the
main form is filled in? Thanks.
 
The BeforeInsert event runs before any data is entered in the form. On the
main form you couldn't run the before insert event after you have entered
data, the event wouldn't run after you have entered data. Once you have
dirtied the form, any code in the before insert event will be completely
missed because the event will never fire.

Jeanette Cunningham


Jeff said:
Jeff,
On the button that opens the popup, put this code to save the record
before
you open the popup.

If Me.Dirty = True Then
Me.Dirty = False
End If
DoCmd.OpenForm "ThePopupForm"

Jeanette Cunningham


I have no problem opening up a 2nd pop-up form that is linked to
another form IF the record from the main form ISN'T new. However when
it is new it NEVER will save the linked record in the 2nd form.
Click to expand...
This is what I mean. On the main form if you enter a new record, in
this case a "Person", then click on a command button, it will open up
a second linked form (it filters the 2nd form by it's "PersonID" ). Of
course in this instance the 2nd form will open completely blank since
there are not yet any related records. This 2nd form has the following
code in it's "Before Insert" event.
Click to expand...
Me.[PersonID] = Me.OpenArgs
Click to expand...
This fills in the "PersonID" on the 2nd form so the two SHOULD be
linked. However as soon as I close the 2nd form, the information IS
NOT SAVED! This ONLY seems to happen if the record on the main form is
NEW. If the record on the main form is a pre-exisitng record, then I
can always open up the 2nd form, and add records, and they are saved.
Click to expand...
The only way to prevent this seems to be to actually do a manual SAVE
on the main form after I enter a new record, and then when I click on
the button to open the 2nd form, and enter data, it is always saved. I
tried adding code to the main form that adds a "DoCmd.RunCommand
acCmdSaveRecord" on the "BeforeInsert" event but this doesn't fix the
problem for some ungodly reason...
Click to expand...
I don't ever remember this happening in Access 2003. Is this some kind
of bug, or I'm I missing something? Any help is much appreciated.
Thanks!
Click to expand...
Click to expand...

Thanks Jeanette, that worked.

However I still don't understand why adding a "DoCmd.RunCommand
acCmdSaveRecord" on the "BeforeInsert" of the main form doesn't do the
same thing. Can you not do the equivalent of hitting the "Save" button
with this command, so the record is saved after the key field on the
main form is filled in? Thanks.
Click to expand...
 
The BeforeInsert event runs before any data is entered in the form. On the
main form you couldn't run the before insert event after you have entered
data, the event wouldn't run after you have entered data. Once you have
dirtied the form, any code in the before insert event will be completely
missed because the event will never fire.

Jeanette Cunningham


Jeff,
On the button that opens the popup, put this code to save the record
before
you open the popup.
If Me.Dirty = True Then
Me.Dirty = False
End If
DoCmd.OpenForm "ThePopupForm"
Jeanette Cunningham

I have no problem opening up a 2nd pop-up form that is linked to
another form IF the record from the main form ISN'T new. However when
it is new it NEVER will save the linked record in the 2nd form.
This is what I mean. On the main form if you enter a new record, in
this case a "Person", then click on a command button, it will open up
a second linked form (it filters the 2nd form by it's "PersonID" ). Of
course in this instance the 2nd form will open completely blank since
there are not yet any related records. This 2nd form has the following
code in it's "Before Insert" event.
Me.[PersonID] = Me.OpenArgs
This fills in the "PersonID" on the 2nd form so the two SHOULD be
linked. However as soon as I close the 2nd form, the information IS
NOT SAVED! This ONLY seems to happen if the record on the main form is
NEW. If the record on the main form is a pre-exisitng record, then I
can always open up the 2nd form, and add records, and they are saved.
The only way to prevent this seems to be to actually do a manual SAVE
on the main form after I enter a new record, and then when I click on
the button to open the 2nd form, and enter data, it is always saved. I
tried adding code to the main form that adds a "DoCmd.RunCommand
acCmdSaveRecord" on the "BeforeInsert" event but this doesn't fix the
problem for some ungodly reason...
I don't ever remember this happening in Access 2003. Is this some kind
of bug, or I'm I missing something? Any help is much appreciated.
Thanks!
Click to expand...
Click to expand...
Thanks Jeanette, that worked.
Click to expand...
However I still don't understand why adding a "DoCmd.RunCommand
acCmdSaveRecord" on the "BeforeInsert" of the main form doesn't do the
same thing. Can you not do the equivalent of hitting the "Save" button
with this command, so the record is saved after the key field on the
main form is filled in? Thanks.
Click to expand...
Click to expand...

Okay, I guess I misunderstood when the BeforeInsert event actually
fires. Thanks for all your help Jeanette.
 
Back
Top