Validating a combobox input

[Marcel2586]

I try to validate the input in a form combobox.
In my table it works okay with a validation rule

validation rule: Like "[A]"
validation text: The input should be two numbers with A or B with two numbers Example: 01A01 or 21B43

But when i go to my form i can still input other letters than A or B.
It will not save but there is no warning that the input is wrong.

 

[jdraw]

Just curious ---Why are you inputting into a combobox?

 

[smig]

There is no need to validate a combo input.
You decide what's in the combo and you can limit to list.

 

[Marcel2586]

Just curious ---Why are you inputting into a combobox?

It has al to do with warehouse.
We have retrievers running through long corridors. There are two of them A-B and C-D.
A and C are the left side and B and D are the right side.
One corridor has 3960 boxes, and they have smaller sub boxes inside. 01A01 trough 44A45 on the left and 01A01 trough 44B45 on the right side. So you could have BIN location 15A33-F.

My database is tracking free locations. Is a part scrapped from 15A33 with sub F, you will get a location free. In the combobox you type 15A33 and press enter to go to the main box and from there you can mark the sub box F, with a X as empty.
Sorry The Database is dutch, but it should not be to hard to understand the purpose.

 

[jdraw]

I looked at your database but I have to disagree with your comment:

it should not be to hard to understand the purpose.

I can see how clicking either of the Retriever buttons requeries the forms with appropriate data. Clicking botlist gives me a blank screen.

You may get some ideas from this video from datapig. I don't know if it's relevant to your process, but it's a simple method to move something from 1 list to another.

Such as Filled Locations to Empty Locations.