Hi

I have a problem which hope will have a simple solution, which has been
driving me mad all day

I have a client who has two prices for the same service depending on speed
of turnaround
These prices are entered into the Client table using the CDetails form. I
then wish to use this information using a combo box for selection within
another form called SDetails.However I can only get the combo box within
SDetails to put one of the two prices rather than either of the two choices,
because of the bound column within the combo.
The combo when pulled down looks something like this

Price 1 Price 2 Client Name

I would prefer for

Price 1
Price 2

so that I have the choice of the price I want to choose.

Having spent time and many brain cells, I have ground myself to a stop.
HELP!!!!!! if only for the sake of my sanity

On Jul 9, 5:02 pm, richard <rich...@discussions.microsoft.com> wrote:
> Hi
>
> I have a problem which hope will have a simple solution, which has been
> driving me mad all day
>
> I have a client who has two prices for the same service depending on speed
> of turnaround
> These prices are entered into the Client table using the CDetails form. I
> then wish to use this information using a combo box for selection within
> another form called SDetails.However I can only get the combo box within
> SDetails to put one of the two prices rather than either of the two choices,
> because of the bound column within the combo.
> The combo when pulled down looks something like this
>
> Price 1 Price 2 Client Name
>
> I would prefer for
>
> Price 1
> Price 2
>
> so that I have the choice of the price I want to choose.
>
> Having spent time and many brain cells, I have ground myself to a stop.
> HELP!!!!!! if only for the sake of my sanity

so what's your question? You want to query the two fields together?
UNION queries are your friend... Either that or use an IIF statement.
IIF(Test=True,TrueValue, FalseValue).