Re: Main form saving when click on subform??? A97

MLH wrote:
It'd normal, it's expected, and you can't change it.

Child records are normally only allowed (by the relationship
setting) when related to an existing parent record. You can't have
an existing parent record unless you save the parent upon moving to
the subform.

Link Child Field and Link Master Field properties for the control
are Null. The subform functions as a glorified listbox control. The
form has worked for about a year w/ no problem. I just did something
in the past 60-90 days that caused this behaviour. It NEVER used to
save the incomplete record on the Main Form before now.

As far as I know moving focus to the subform is equivelant to moving to a
different record. The record in the main form is saved. The MasterLink and
ChildLink properties have nothing to do with it. Doesn't even matter if the
subform is unbound.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Coding and trapping event for subform add new record
    ... I have a main form and a subform. ... There can be many child records for a single parent record. ... I could set the subform's property to AllowAdditions = TRUE, ...
    (microsoft.public.access.formscoding)
  • Re: Main form saving when click on subform??? A97
    ... turn into a triangle when you step into the subform. ... Child records are normally only allowed (by the relationship ... setting) when related to an existing parent record. ... an existing parent record unless you save the parent upon moving to ...
    (comp.databases.ms-access)
  • RE: New Records not created in a nested form having subforms
    ... The way to relate records in the subform the the parent records in the main ... parent record the relate to the child record in the Link Master Fields ... SQL query, set up tables, etc) to access data from a outside table ...
    (microsoft.public.access.formscoding)
  • JOIN query: What happens when you delete a row?
    ... Start with two tables, parent records in one and child records in the other, ... Now display fields from that query in a continuous form. ... one of the child records AND THE PARENT record are ...
    (comp.databases.ms-access)
  • Re: Still not able to UNDO a new record entered
    ... > well as required field in subform. ... > only exist with a child record. ... "parent" record on the main form, and therefore the parent record must ...
    (microsoft.public.access.formscoding)