Please Help: two subformas feeding from the same table

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

Guest

Please help me,

I have a table that is being populated on a bi-weekly basis. I need to know
the changes in different fields per date of the update. I have created a form
with two sub forms in it. Both sub forms are pulling the information from the
same table. I also have a combo box that populates these sub forms by date.

I would like to be able to have one sub form display a chunk of date per
date A and the other sub form the data from Date B - by clicking a command
button I would like the third sub form to display the difference between the
two per date and ID number.


I hope this is not to confusing, please help.
 
Jeka,

In my opinion, doing these data manipulations on the forms is
unnecessarily cumbersome. If it was mine, I would do it with queries.
A simple example would be:
- make a query to return the data for Date A
- make another query to return the data for Date B
- make a third query that joins the first 2 queries, which can include
the summary data from each of the 2 dates, as well as calculated fields
to get the difference values.
- make a single form based on this third query, which will show all of
the information you are presently trying to use 3 subforms for.
 
Back
Top