Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Check if ID Already Exists

Status
Not open for further replies.
JeffAlton

JeffAlton

Programmer
Apr 19, 2003
42
US
I have an access form for adding new vendors. The vendor number is not autonumber it is just a text box. When adding new vendors I get errors if the ID already exists. How can I Check after update of the text box if the ID already exists in the source table?
 
Sort by date Sort by votes
How are ya JeffAlton . . . . .

Have a look at the [blue]DLookup function[/blue].

Calvin.gif
See Ya! . . . . . .
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

I
  • Locked
  • Question
How to get 2 codes to work together.
Replies
6
Views
753
hermanlaksko
hermanlaksko
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Cannot add Image to Command Button?
Replies
9
Views
1K
PrimoSteve
PrimoSteve
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
533
renigar
renigar
rdpress
  • Locked
  • Article
Determine if Close Button is Used to Close Form 1
Replies
3
Views
312
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top