More continuous form issues. (2000)

Topic

New Reply

I am building an ordering system/POS for a friend’s business.

I’m trying to use a continuous form for the main screen.

I’m having issues with the calculation of the totals in a timely manner. In the attached, I can calculate the totals, but only using a timer event. When the timer kicks off, I get the “Calculating…” message in the status bar. Annoying. Also, if I make the timer fire too often, the screen flashes. Too slow, and my totals aren’t always accurate. Is there a better way?

Reply | Quote

Replies

You should put a text box in the subform’s footer to calculate the sum of the extended price (using the expression mentioned by SteveH in your previous thread). You can then place a text box on the main form that refers to the text box on the subform, and hide the text box on the subform, or even the entire subform footer.

Reply | Quote

SteveH’s suggestion did not work for me.

I ended up writing some code to fill in the fields on the bottom of the form.

Also, it is not a sub form, just a regular form.

Reply | Quote