Data in subform not saving

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 ??
 
T

tina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top