Combo Box Help

[peckitt99]

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

 

[MStef]

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.

 

[peckitt99]

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

 

[Fear Naught]

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.

 

[MStef]

Thanks Fear Naught,

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