Subform data not showing

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I have a form that I enter orders on and in a subform I
bring up all prior orders by this same customer. I have
been successful in doing this on set up. But when I enter
a new order my subform doesn't display unless I click on
the design view and immediately click back to the form
view - then it displays exactly what I want. Is there a
way to set this so it automatically shows up?
 
In the AfterUpdate event of the main form but a code line like:
Me!subfrmControlName.requery

to have your subform requery its recordsource and read the new record. BTW,
most apps are designed so that the main form shows the 1 side of the
relationship and the subform shows the many; i.e. main form shows customer
record, and subform shows all orders for that customer. A command button
could popup an entry form to add a new order for that customer.

-Ed
 
You must log in or register to reply here.

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

Similar Threads

Click a subform field to open relevant form 5
Subform Question 3
Unremovable horizontal scroll bar on subform 1
Subform problem 4
Copy Data from Subform 4
filter query on combo box in a continuous subform 0
Subform has disappeared from Main form 5
Using an append query in a subform 1

Back
Top