Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 25th, 2005, 05:49 PM
Registered User
Join Date: May 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to find record, if not found add in form

Okay, to some this is so easy, but i am stumped. sorry wrox book is not working for me. ex-cobol programmer learning vb.
I have a form with data, I need to search that form for field called weight# ( i used a the wizard and it works), but if it is not found, I need to open a new form in add mode, if found open that form in edit.

anyone can help me...............

Old May 27th, 2005, 10:58 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Set the combo box Limit To List property to NO.

Then set the combo box On Not In List event to open the form in edit mode on a new record.

See the Microsoft MSDN web site for further details. Do a search for Access On Not In List.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Open Form to Add New Record is Blank echovue Access 9 July 10th, 2013 03:38 PM
Add Record to table from form AlForum29 Access VBA 2 January 2nd, 2013 09:46 PM
Add record form bunkerbang Access VBA 5 September 12th, 2007 12:17 AM
How to add new blank record to data form? Kia Visual Basic 2005 Basics 1 June 12th, 2007 02:11 AM
add a record to yes/no control form VB carlos1972 Access VBA 2 April 6th, 2006 10:01 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.