Validation Rule

[esskaykay]

Is it possible to set a Validation Rule for a form input field based on a field in a different table? I have a small table (tblSuffix) with road name types (i.e., STREET, ROAD, AVENUE, LANE, etc). I can add these separatly to the validation rule on the form's properties field, but it would be nicer if once the tblSuffix table is changed, it automatically changes the validation.

I have added a combo box to my form linked to the tblSuffix table. This works fine. However, because of hte lack of space, I'd like to not have the drop down option (i.e., remove the selection arrow). Is this possble?

Thanks,
SKK

 

[Uncle Gizmo]

Personally I would go for the combo box option, Set the combo box to only allow items to be selected from its data source.

I am puzzled as to your concerns over lack of space, this is the point of a combo box it allows you to use limited space effectively.

 

[stopher]

Is it possible to set a Validation Rule for a form input field based on a field in a different table? I have a small table (tblSuffix) with road name types (i.e., STREET, ROAD, AVENUE, LANE, etc). I can add these separatly to the validation rule on the form's properties field, but it would be nicer if once the tblSuffix table is changed, it automatically changes the validation.

If you want to limit input to only the values in tblSuffix then you need to create a relationship (in the relationship window) between tblSuffix and the destination table. This will ensure no other entries are allowed. This is the way to perform this kind of validation in a relational database.

As, Uncle Gizmo says, use a combo. Then set the source for the list to tblSuffix.

However, because of hte lack of space, I'd like to not have the drop down option (i.e., remove the selection arrow). Is this possble?

Perhaps you could post a screen shot and maybe people could make suggestions how to improve the space issue. There are lots of useful tips in this topic I think.

hth
Chris

 

[esskaykay]

I meant lack of screen space. I wanted three fields in a line. Howver, one of them was quite long. I guess it's working OK now.

Thanks for your time,
SKK