Hi All
I have a form with a large number of text fields which simply display a high and low price for a range of products. Each field as the following code:
=DLookUp("PriceCorrect","tblpricelist","ProductID = 52")
I now need to add discounts prices but only for certain customers so I need to switch the code of each field to something like
=DLookUp("PriceDiscounted","tblpricelist","Product ID = 52")
this would change if the customer is flagged as being allowed discount. I don't want to create a new form and re-code each of the fields I want the field source to change automatically when the form opens.
Is it possible to change the field source programatically on the on open event.
Thanks