Choice Problem

[Guest]

I'm setting up a ticket booking database but on the bookings form I want to
restrict the price of tickets if the performance is a certain day. I have a
combo box to select the performance day and a combo box to select the ticket
prices. When I select "Tuesday" I only want the ticket prices to be £8.00 and
not to have a choice. Can anyone help, please.

 

[Allen Browne]

Presumably this combo has a RowSource that gets its values from a table?

Change the RowSource to something like this (substituting your own field
names, of course):
SELECT IIf(Weekday([BookingDate])=3, 8, [MyPrice]) AS ThePrice FROM
Table1;

 

[Guest]

The combo box that contains the prices are typed in rather than selecting
from a table or query.

Presumably this combo has a RowSource that gets its values from a table?

Change the RowSource to something like this (substituting your own field
names, of course):
SELECT IIf(Weekday([BookingDate])=3, 8, [MyPrice]) AS ThePrice FROM
Table1;

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I'm setting up a ticket booking database but on the bookings form I want
to
restrict the price of tickets if the performance is a certain day. I have
a
combo box to select the performance day and a combo box to select the
ticket
prices. When I select "Tuesday" I only want the ticket prices to be £8.00
and
not to have a choice. Can anyone help, please.

 

[Allen Browne]

If the RowSourceType is a ValueList, then you will need to assign a new
Value List (with just one item - the 8) if WeekDay([BookingDate] = 3.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

The combo box that contains the prices are typed in rather than selecting
from a table or query.

Presumably this combo has a RowSource that gets its values from a table?

Change the RowSource to something like this (substituting your own field
names, of course):
SELECT IIf(Weekday([BookingDate])=3, 8, [MyPrice]) AS ThePrice FROM
Table1;

I'm setting up a ticket booking database but on the bookings form I
want
to
restrict the price of tickets if the performance is a certain day. I
have
a
combo box to select the performance day and a combo box to select the
ticket
prices. When I select "Tuesday" I only want the ticket prices to be
£8.00
and
not to have a choice. Can anyone help, please.