sub forms which do not update automatically

[AlexL]

Hello there,

I'm having a problem with my subforms in Access 2007. When I make
forms using the wizard and embed subforms it is fine. I make a new
booking on the bookings form and when I select a new customer ID
(master and child field) the customer details display on the subform
as I would hope.

However when I make custom forms from scratch and use subforms the
subform will not update even though I do correctly set master and
child field. the subfroms work when you skip through the records but
when i make a new record the subform does not automatically display
the linked customer details. I can rsolve this using VBA code and
have done but I am sure there must be a property which deals with it
quite simply - does anybody know what I'm doing wrong?

Many thanks

Alex

 

[Tom van Stiphout]

On Wed, 1 Oct 2008 01:01:11 -0700 (PDT), AlexL

My guess is that you are not setting LinkMasterFields or
LinkChildFields correctly, or possibly that the subform query is
incorrect.
If it is true what you say that the wizard can do it correctly for
you, make it create a new form and carefully study the differences
between it and your form.

-Tom.
Microsoft Access MVP