Validation Rule Problem 1

[rilkyn]

I have a view form which lists records based on a selection from a combo box. The combo box selects its records from a column on the same table.

eg

table Element has the following

Element Gold

apib001 Yes
apib002 No
apib003 No


On the form the combo box is populated by the element column but if I typed 'test' in the combo box the Gold field would be populated with 'Yes', inferring the 'test' was a record on the table.

What I have tried to do is set up a validation rule using the expression builder to validate the the value entered in the combo box matches a value on the element column on the table. Unfortunately this has not worked.

Can anyone help or advise me if there is an alternative/better way of getting around this problem?

 

[PHV]

Without the RowSource propertu of the combo it's hard to say anything.
Perhaps the LimitToList property ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rilkyn]

Thank you

Setting the flag on Limit To List works fine. I now get an error message when a record entry does not match the table.

Exactly what I am looking for.

Thnaks

Craig