Combo Box Help

peckitt99

Registered User.
Local time
Today, 19:58
Joined
Sep 24, 2007
Messages
23
Hi

I was wondering if it was possible to create a combo box that can delete entries once clicked on them

for example for a booking system for a dental practice i want a combo box that will show a list of available times. once a user has selected a time, no one else can select that time so it is deleted off the combo box so it is not visible, aslo if that appointment gets cancled then it will re-appear for someone else to select.

can anyone help me with this?

Thanks
 
I can offer you a "DemoComboWA2000.mdb" (attachment).
In this mdb you can see a similarly combo in "FormCastInfo".
Try to adapt it on your MDB.
Look at tables, query. Look at VBA.
 

Attachments

Hi

That is exactly what i want, i went through everything on that database onto mine but was unable to get it working

is there any chance of a step by step guide on how you did this?

Thanks
 
Excellent example MStef. I will certainly use it.

peckitt99 - the key is the query behind the combo box that select only unused numbers and the requery statement on the form tha allows the combo to be updated.
 
Thanks Fear Naught,

peckitt99, if you can't to adapt it, send a short example of your MDB, (A2000 or A2002).
 

Users who are viewing this thread

Back
Top Bottom