Form with subform not refreshing

[Guest]

I have a main form that contains a drop down box linked to my table of
customers. I have a subform that lists all the orders from that customer.

My problem is that my main form retains the last customer looked up and also
my subform includes my First order record (even though it doesn't belong to
that customer) and when I choose another customer, my first order record is
changed to the retained customer.

How do I fix this?

 

[Roger Carlson]

It sounds to me like you have not set the LinkChild / LinkParent properties
of the subform control properly.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

How am I to know which is susposed to be the Child and which is the parent?

 

[Roger Carlson]

The parent is the field on the main form and the child is the field on the
subform that you want linked.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Roger,
First I want to thank you for your help.

My main form and my subform are linked together using the Customer Name
field. Parent / Customer name / Main form - Child / Customer Name / Subform.

My form works properly when I choose another customer therefore I believe
the parent/child is correct. It is only when I return to the form. It retains
the last lookup AND shows the first order record belonging to that retained
customer.

Is there a way to make the main form NOT retain the last lookup customer? Or
is there a way to make the subform NOT update until AFTER a new customer is
chosen?

Tami

 

[Roger Carlson]

I guess I'm confused when you say "return to the form" it "retains the last
look up" I'm not sure what you are referring to. Can you explain a little
more?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

I have a table of Customers. And I have a table of Orders which were bought
by these customers. I created a form called Find Orders by Customer. It was
my intention to have a drop down list of my customers on the main form and a
subform that contained all the orders for that customer.

This form ONLY has one input field - the drop down list of the customers.
The subform is read only except for the command button that takes you
directly to the order.

For example company ABC bought our 1st order, and DEF bought our 2nd order.

When I choose a customer DEF, the subform shows me order #2 plus any others
that they purchased. (Works great the first time.) I close my lookup form.
Later I go back in it and company DEF is still in the drop down box AND order
#1 which belongs to ABC is in the subform. If I click on the command button
that takes me to the order, the customer on the order is changed from ABC to
DEF.
Tami

 

[Roger Carlson]

Is the main form bound to your Customers table? The main form must be bound
if you want to use the LinkParent/Link Child properties of the subform.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L