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

On Wed, 30 May 2007 22:47:34 -0500, "Rick Brandt"
<rickbrandt2@xxxxxxxxxxx> wrote:

That is correct. You can show the RecordSelector and see the pencil
turn into a triangle when you step into the subform.

-Tom.


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.

.

Relevant Pages

  • Re: Form to search database and return found records
    ... I created a query that pulls in required data from all four tables. ... The way you keep a subform in sync with the main form ... the mainform) is by using the Link Master Fields and Link Child Fields ... identify the fieldin the Master record that point to the child records in ...
    (microsoft.public.access.forms)
  • Re: Form to search database and return found records
    ... and one property can have multiple owners. ... with the subform. ... the mainform) is by using the Link Master Fields and Link Child Fields ... identify the fieldin the Master record that point to the child records in ...
    (microsoft.public.access.forms)
  • Re: Main form saving when click on subform??? A97
    ... 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 ... The subform functions as a glorified listbox control. ...
    (comp.databases.ms-access)
  • 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)
  • Add a new data in Main and Subform ?
    ... This textbox is not bound. ... The Main and Subform has a parent/child relationship linked by ... If it exists in the table, then retrieve its child records in the subform ... Dim strSQL As String ...
    (microsoft.public.access.formscoding)