Validate Data in SQL table

I have a form that the user enters values on it. One of the fields I need to
validate what is being entered against records in a SQL table.
Something like doing a findfirst in Access and then doing a nomatch.
How do I go about doing this?
Thanks In Advance,
LouU¿ytkownik "Lou Civitella" <lou@.webersystems.com> napisa³ w wiadomo¶ci
news:ewjBafHuEHA.2300@.TK2MSFTNGP09.phx.gbl...
>I have a form that the user enters values on it. One of the fields I need
>to
> validate what is being entered against records in a SQL table.
> Something like doing a findfirst in Access and then doing a nomatch.
> How do I go about doing this?
Create command (text or stored proc) that will check data in SQL Table.
Regards,
Grzegorz
Hi Lou,
Change the textbox to a combobox; then load the data from the table into the
combobox and the user can only pick valid data, by definition.
HTH,
Bernie Yaeger
"Lou Civitella" <lou@.webersystems.com> wrote in message
news:ewjBafHuEHA.2300@.TK2MSFTNGP09.phx.gbl...
>I have a form that the user enters values on it. One of the fields I need
>to
> validate what is being entered against records in a SQL table.
> Something like doing a findfirst in Access and then doing a nomatch.
> How do I go about doing this?
> Thanks In Advance,
> Lou
>