Data in subform not saving

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables that I have created 1) Customers 2) Orders -- (the
customers table has a subform to another table, but all is well with the
'customers' form. When I pull up the customers form I have added a function
button that opens the 'Orders' form - when it opens, 2 fields on the 'Orders'
form are pulling from the input of the 'customers' form -- (which is what I
want) however, from that point, when I fill out the rest of the form to enter
an order for that customer, all saves EXCEPT for the cross-referenced fields
(and therefore I cannot look up the orders by customer once I save them) --
I've set the relationship between the tables by CustID (one to many) -- Not
sure what I'm doing wrong here --

Can anyone give me a clue ??
 
a "subform" is, by definition, a form opened *within* a mainform, using a
subform control in the mainform .if you're opening the Orders form in a
*separate window*, there is no automatic link between the two forms (as
there is with a mainform/subform setup), even though there is a relationship
set between the underlying tables. if you want to use a separate form, set
the default value of the cross-referenced fields in the Orders form to the
values of those fields in the record on the Customers form.

hth
 
Back
Top