Validation Rules

[Jason Wills]

I would like to create a validation rule on a lookup field in a table.....

the lookup table works fine, but i would like to make sure that people don't
type in anything in the field rather than use the lookup.... as this would
add a new record in the table with a name that i dont have control over

Any ideas would be great...

Cheers

Jason

 

[Rebecca Riordan]

Set the LimitToList property to True on the Form

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[Tim Ferguson]

but i would like to make sure that people don't
type in anything in the field rather than use the lookup

That is not a job for a ValidationRule, it's a job for Referential
Integrity. Creating a relationship means "this field can only contain a
valid value from that table". As long as that rule is kept it doesn't
matter how the value gets there: e.g. combo box, text box, VBA, Excel, MS
Query etc etc etc.

B Wishes


Tim F

 

[Jason Wills]

thanx for your responses, referential integrity unfortunately didn't work
for me, the list was already populated with other stuff, so i couldn't force
the integrity, but i understand that if i had designed it like this to start
with then i wouldn't have had the problem now.

fortunately the other post worked great, (setting the LimitToList property
to true)..

thanx both of you

regards

Jason