Calculate field after combo update

[TinaCa]

I tried to do this with one query but the data was incorrect - probably because of the joins. I need two Sums from two different tables. Then I need to add those two sums together. So on the form, after a user selects 1 or 15 (billing date of the month for companies) I have the system do a refresh which updates the (listbox) fields txtExtras and txtMonthly. The first is a sum of the extras for a company that have not been billed and the second is sum of all companies that get billed on the date chosen my the user (1 or 15).

Now, I want to add txtExtras and txtMonthly in another field on the form. I have tried using a list box with the recordsource set to add the two fields - no go, I have tried a text box with the caluclation as the controlsource - also no go. I have tried adding them in code after the refresh still no go. Any ideas?

[alansidman]

I believe that your issue is that a form may have only one record source. You will need to do the sums in a query (joining the two tables), then in a subform on your main form, make the new query the record source. You will need to create a parent/child relationship between the form and subform so there needs to be some common field.

[TinaCa]

That's not accurate. Each list box is already pulling data from two different sources. The form itself does not have a recordsource - think of a form you would use to display and run a list of reports. You put in criteria and click on the appropriate button and the report you selected runs, i.e. the form has no recordsource.

[alansidman]

I can't visualize this. Perhaps, you should post a copy of your db so that others more experienced than me can assist as I am sure that may be an issue.