(Office2007) make dropdown menu elemtn not available if i selct it

[tarek_ta2ta2]

i have a simple database that to store things in specific locations

i put the elements name and select the places from dropdown menu and save it .. the problem is :

i store element A in Place A when i go to store element B i don't wanna place B to be Available

 

[Uncle Gizmo]

Assuming your combo box is based on a query, changed the query so that it only displays the top (1) record.

 

[tarek_ta2ta2]

sorry if i didn't get it , but i don't use any query

i just have one table and one form

it's more than simple database

i add teh data in teh row source for the drop down menu

hope i make it alittle clear

 

[tarek_ta2ta2]

please i just need clarification if it's possible or not

i really need help in this