Search results

Seeing as the calculated fields are working in report view. I don't think its a syntax error. I suspect it might have something to do with the Reports On No Data Event possibly?

Thanks for your suggestion. I implemented your solution and then got a new "error" in Print Preview Only

Good day again everyone. Hope all is well :). I have a strange one. I have a report that shows information from 3 Subforms (linked by Primary key). At the end of the report are some Text Fields running calculations. This is all working smoothly in Report View (Fields in Red are usually...

Thanks for your assistance, arnelgp's suggestion worked.

You sir are a legend. Spent hours trying to figure it out before visiting here. Really appreciate your assistance!

Good day everyone. Please could you lend a Machete to my intellectual bush. I have an Invoice form that calculates values from 3 tables (Master Fields Linked by Primary Key). However, whenever a single table (Cost in this case) has no records. The Calculation fields stop working. I've...

Thank you for this solution. I like this approach. Just a quick one, why is it not recommended to store the quantity in a table? I was thinking of adding a method whereby quantity items are removed at the Invoicing stage. This way I can keep track of item's allocated to which job, when...

Thanks again everyone. For anyone else who would like to know what this look like, below are some screenshots. FYI this is called a Relational Combo Box: Create the Query Add a Combo Box to your Form Then point the Combo Box to your Query

I really appreciate the advice. I'm going to try this and get back to you.

Thanks for the suggestion, I didn't know that Combo box's could be filtered. I'll look into that!

Thanks for taking the time to assist. Its a sub form, but yes it is bound to the Query.

Hi everyone! Please can you shed some light on my storm of confusion. I want to create a stock control method wherby when a stock item reflects 0 quantity items then it shouldn't be able to be selected for future allocations. I have 2 tables "StockT" & JobCostT". The tables are joined by a...