Change field and label names in data set form view of query

[Smythe32]

Hi,

Here is my dilemna and not sure how to solve it. I have a form bound
to a query. Lets say we are looking up telephone numbers. There are
multiple instances of each phone number in the table with different
types of orders in the same table. So, when I look up the telephone
number, it can give me 2 records for the same telephone number but
they can have different order types. So, for ex: Order type 1, I
want the field label1 to say "Order Date", if the Order type = 2, I
want field label1 to say "Cancel Date".

I am not quite sure how to accomplish this because if you scroll
through the records, it doesnt change the field label1. It stays at
whatever the first order was that came up first.

Any help would be appreciated.

Thanks,
Teresa

 

[Marshall Barton]

Hi,

Here is my dilemna and not sure how to solve it. I have a form bound
to a query. Lets say we are looking up telephone numbers. There are
multiple instances of each phone number in the table with different
types of orders in the same table. So, when I look up the telephone
number, it can give me 2 records for the same telephone number but
they can have different order types. So, for ex: Order type 1, I
want the field label1 to say "Order Date", if the Order type = 2, I
want field label1 to say "Cancel Date".

I am not quite sure how to accomplish this because if you scroll
through the records, it doesnt change the field label1. It stays at
whatever the first order was that came up first.

Change the label to a text box and use a control source
expression like:
=IIf(OrderType = 1, "Order Date", "Cancel Date")