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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DLookup in Form for duplicates accounts

Status
Not open for further replies.
mauricionava

mauricionava

Programmer
Jul 8, 2005
209
0
0
US
Hello there,

I have a form linked to tblMain. In the form I have to enter some data (acct number, buyers name, etc). I want the Save button to do a DLookUp on the ACCT field in the tblMain to see if the account has already been entered in the table. I would like to display a message that would say "Please change the account number". Thank you!!!
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
119
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
84
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
200
dhookom
dhookom
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
61
dhookom
dhookom
renigar
  • Locked
  • Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
76
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top