Hello,
I have another strange problem. I have built a query with calculated fields for my sales colleagues to enter price data for customers
I have designed a popup form where a single customer must be selected initially (to avoid mixing up price conditions). If this is done, the user pushes a button a form with the underlying query is loaded. I use VBA code to alter the record source property with the user selection (customer).
However, some of the calculated fields in the loaded form now return errors. If I open the form in design mode and reload it again everything is fine!! Could anybody tell me what might be going wrong when loading the main form with the popup.
Thanks.