Update Tables from Combo Boxes in a Form

[RedWolf3x]

Ok So I've created a Database to track phone calls coming into a call center.
(Originally created in Open Office, but then we switched to Access)

I've got a form that has buttons to run multiple reports.

The Reports pull data from a table based off dates found in another table
(Something I used in Open Office)

Table 1 has all the phone calls

Table 2 has a From date and a to date

The report pulls the phone calls in table 1 between the dates in table 2.

In open office I used Subforms (Which were seemless) and combo boxes to update the dates in Table 2 before running the report.

Is there an easier way to accomplish this in Access? If so How?



If Not, is there a way to make a seemless subform in Access?
How again?

Thanks.

-Red

[TheShabz]

First off, what are the contents of the two tables? I'm not sure why you would be storing just dates in a second table. How is it related to the first one?

[RedWolf3x]

The first Table has the calls and the scores from the calls (including the dates the calls were taken). The second table has the dates to be used as a begin and end date for the query tied to the report.

The Form Will have two fields that Update the From Date and To Date in Table 2 With a button to open the form.

Table 1
Call # Call Date Rep Time Score
Call 3 08-25-11 John 1:11 100
Call 2 08-2-11 Steve 2:04 80
Call 1 07-2-11 John 5:04 100

Table 2
From Date To Date
08-01-11 08-25-11

Report returns Calls 2 and 3
Call # Call Date Rep Time Score
Call 3 08-25-11 John 1:11 100
Call 2 08-2-11 Steve 2:04 80

Thanks again.

-Red

[RedWolf3x]

I found a better solution to this issue. I've started to pull the data directly from the form. I was unable to accomplish this in Open Office where the database originated. Tahnks for the help.