change values in combo box depending on usage.

[helraizer1]

Hi folks,

In my database I have a form, one of the fields is a drop down list, which in the table it relates to is unique. How can I make it so that when a user selects that one and saves their record, next time it won't be in the list?

Hope that makes sense,
Sam

[zaidlig]

Hi folks,

In my database I have a form, one of the fields is a drop down list, which in the table it relates to is unique. How can I make it so that when a user selects that one and saves their record, next time it won't be in the list?

Hope that makes sense,
Sam

If understand you you want the drop down list to be reduced every time someone selects an item?

Set the drop down list rowsource to a query that compares what has be used against what is available - only showing what has not been used.

[FishVal]

Hello, Sam.

Take a look at this thread

Regards,
Fish

[helraizer1]

If understand you you want the drop down list to be reduced every time someone selects an item?

Set the drop down list rowsource to a query that compares what has be used against what is available - only showing what has not been used.

Yeah, there is a time slot for each ride in the database. 15 slots per ride, so say someone books one of those, next time they or someone else tries to book one there'd then be 14 slots available.