By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,140 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,140 IT Pros & Developers. It's quick & easy.

change values in combo box depending on usage.

100+
P: 118
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
Jan 11 '08 #1
Share this Question
Share on Google+
3 Replies


P: 45
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.
Jan 11 '08 #2

FishVal
Expert 2.5K+
P: 2,653
Hello, Sam.

Take a look at this thread

Regards,
Fish
Jan 11 '08 #3

100+
P: 118
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.
Jan 11 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.