Hi,

Hope someone have quick answer to my question.

I have a table call "IssueTable". I want to code to find out whether the
user inputed informaiton is in the IssueTable before user enter it in the
table.

I don't want to duplicate the issue in the issuetable. Therefore, I want to
check it before I enter it as new item.

In the Usertable, there is the Authrization# field and if user enter part of
Authrization#, I want the code to check if the User input is in the Issue
Table.

Thanks

Use DLookup(). For examples, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

Something doesn't feel quite right though. In general, you would want to
design your tables so there's only one table where all the authorization
numbers go.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Richard" <(E-Mail Removed)> wrote in message
news:B157839E-2F2E-4329-953E-(E-Mail Removed)...
> Hi,
>
> Hope someone have quick answer to my question.
>
> I have a table call "IssueTable". I want to code to find out whether the
> user inputed informaiton is in the IssueTable before user enter it in the
> table.
>
> I don't want to duplicate the issue in the issuetable. Therefore, I want
> to
> check it before I enter it as new item.
>
> In the Usertable, there is the Authrization# field and if user enter part
> of
> Authrization#, I want the code to check if the User input is in the Issue
> Table.
>
> Thanks

Richard, I'm not sure I understand this question. What language do you speak
normally? If you write it your native language, assuming it's not something
exotic like Serbo-Croation or Turki, I might understand it better. Or you
could re-try English, just rephrasing it.

To save time, I'll guess (but I don't guarantee I'll guess right): If
you're trying to prevent Issues from being entered in the Issue table more
than once, why not design the Issue table to forbid duplicate keys?

--- "Richard" wrote:
> I have a table call "IssueTable". I want to code to find out whether the
> user inputed informaiton is in the IssueTable before user enter it in the
> table.
>
> I don't want to duplicate the issue in the issuetable. Therefore, I want to
> check it before I enter it as new item.
>
> In the Usertable, there is the Authrization# field and if user enter part of
> Authrization#, I want the code to check if the User input is in the Issue
> Table.