Change Text Box Data Source On Open Event

[mcktigger]

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

[June7]

Use an IIf expression in the ControlSource

= IIf([FlagField]=True,DLookUp("PriceDiscounted","tblpricelist","Pr oductID = 52"),DLookUp("PriceCorrect","tblpricelist","Produc tID = 52"))

or

= DLookUp(IIf([FlagField]=True,"PriceDiscounted","PriceCorrect"),"tblpricel ist","ProductID = 52")