Search results

I hope this is a no-brainer. I have several fields from 2 subforms that are added together to display totals on the main form. When 1 subform returns no values, the total calculation displays #Error on the main form. Is there a way to get the fields on the subforms to have a default value of...

I am using a query to populate a continuous form, in the form footer I am adding fields that total the results of the query. This works fine for a while then I will start getting #Error in the total fields only. The form displays rows of invoice numbers and cash, I total the cash with...

I am using a continuous form that displays lines of summary info for each invoice number, when you click on the invoice number the hidden details fields appear for each invoice by using the Click event to change the fields to visible. How can I get the fields for just one of the invoice numbers...