Validate field against another field

[Dansbo]

Hi,



Excuse med, but I have been looking through the net at no avail.

I have created a for in a database where I want to validate the data given by a user against another field.

I.e. A table has been created for users to type in manually installed software om a given computer name. Now I want to have access to check the given computer name against another field in another table I have made where all computer names are listed.

I have tried dlookup and just using =.

Could someone please help?

THX in advance

[ranman256]

you can make it a pick list, so the user can ONLY pick correct computer names.
or
once entered, validate the entry using DLOOKUP,
user enters in txtPCname,
afterupdate event checks the entry,
if txtPCname <> Dlookup("[pcName]", "table", "[pcName]='" & txtPCname & "'" then msgbox "pc not found"