AutoLookup does not work on a Data Access Page (article 202144)

=?Utf-8?B?R2lsbGVzQUJlbGFuZ2Vy?=

Guest

Posts: n/a

10th Nov 2006

Do someone knows how to code the situation where a match is not found with
the AutoLookup sub?

If there is no match, I want to see empty values in my fields and a MsgBox
that says that "Value could not be found in the associated table", not an
error message from access.

Thanks

--
GillesABelanger

« Error Creating Data Access Page | Go To Specific Record Via Shortcut »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot get Data Access Page to work with Queries	ArtScope	Microsoft Access VBA Modules	0	25th May 2006 10:10 PM
I want to create a Journal Article Database, would Access work??	=?Utf-8?B?TWVnZzAwMQ==?=	Microsoft Access	2	19th Mar 2006 11:31 PM
Parameter Query to work as a Data Access Page	Carrie Horvath	Microsoft Access Queries	0	23rd Sep 2005 08:41 PM
How do I get timer event in a data access page to work	Henrik Aronsson via AccessMonster.com	Microsoft Access	0	17th Mar 2005 06:06 PM
Access 2000, Data Access page does not work when run on network drive.	Steve Hastings	Microsoft Access	0	8th Aug 2003 03:21 PM