Creating Access 2007 Macro that will accept user input to search for a value

strappyblues strappyblues is offline

New Member

Join Date: Mar 2010

Posts: 1

31st Mar 2010

I would like to create a Microsoft 2007 macro that will prompt a user to enter a report number and then search for and return the record from a form. I would like to either use SearchForRecord or FindRecord. Can anyone help? I looked online I could not find any examples to modify for my use. I do not want the search string to be hard-coded in the macro.

« Report base on a query from a form? | backup of data base via macro? »

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
Creating a multi-step custom macro-Access 2007...	Lauren	Microsoft Access Macros	0	20th Jul 2009 12:51 AM
Creating user input Search with 3rd party search engines	phl	Microsoft ASP .NET	0	19th Feb 2008 05:11 PM
Creating a Search Engine with Access 2007	=?Utf-8?B?c20xMDU=?=	Microsoft Access Queries	2	28th Apr 2007 05:38 PM
Newby help! Creating user-input defined search queries...	=?Utf-8?B?RWQgRw==?=	Microsoft Access Queries	3	28th Apr 2004 02:41 PM
ie 6 browser search bar will not accept input		Windows XP Internet Explorer	1	28th Feb 2004 02:30 PM