I have a combobox that is pulling pallet numbers from a pallet lookup table.
Once the user selects the pallet number from the combobox, it flags the pallet number from the pallet lookup table and sets it status as used.
The next user only sees available pallet numbers.
Here's my problem if they accidently select the combobox and delete the value listed they cannot select it again unless I reset the status to available.
I know in VB there is a drop down list that is read only. Access only has a drop down list for dataaccess pages.
What I want is once they have selected the correct pallet # then they cannot delete it from the text box area until they have finished scanning. The they click End Scan button and it resets the combobox with "".
Is there a solution to my problem in Access?