form control errors

[Suzie2012]

Im creating a form to show how much money should be in our cash register based on invoices.


On this form i have several fields, Service total, Products Total, and Concessions total.

The Service total and Products Total Sums are on the same query. but the concessions is built in a separate query since its information is kept in a separate table.

Im having issues putting issues putting the totals from both queries on the same form. if i build the form linked to the service totals, it wont show the concessions total, and vice versa. and if its not linked to either table then it wont fill any of the fields.

Im using Macros and expressions, not VB

If i create a macro to populate the field I'm getting the error message "The Object Doesn't Contain the Automation Object ..."

[pbaldy]

You could insert a subform based on the second query into the existing form. You could also use a DSum() in a textbox.

[Suzie2012]

i figured out how to populate the unbounded txt boxes with the info i need, by use of macros, but now i cant get them to be shown ina currency format, i have changed the format for the txt box in the properties, but they are still showing as a general number and not a currency, any suggestions?

[pbaldy]

How are you populating them? My guess is that something in the method is causing them to be seen as text.

[Suzie2012]

Here is some pics of how im populating the fields. the value from the tables are set to currency