I have a control on a subform that I need to populate with values from one of two possible tables.
The sub form is is populated from a table called SummaryLine. SummaryLine has a field called Price.
I want the control txtPrice to get it's value from SummaryLine.Price, unless Price is empty...