Print Page | Close Window

ComboChoosesRecord.mdb (beginner)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=379
Printed Date: 23 Sep 2020 at 9:51am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: ComboChoosesRecord.mdb (beginner)
Posted By: Roger Carlson
Subject: ComboChoosesRecord.mdb (beginner)
Date Posted: 01 Aug 2008 at 7:35am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .

ComboChoosesRecord.mdb

This illustrates how to have a combo box in which you can choose a value and have that record appear in the form. The important code for this is in the AfterUpdate event of the cboISBN control.

The combo box wizard will do this for you automatically. In the second step, choose the third option: "Find a record on my form based on the value selected in my combo box" This must be done on a BOUND form.

Form: Books2 shows a variation to this with 2 columns in the combo.

Form: Books3 shows yet another variation which allows you to choose by either ISBN or Title and the value automatically updates the other combo.
 
Download

Access 2010-2019 accdb:  uploads/5/ComboChoosesRecord_2010.zip" rel="nofollow - ComboChoosesRecord_2010.zip
Access 2000 (53 KB):  http://www.rogersaccesslibrary.com/forum/uploads/5/ComboChoosesRecord2k.zip" rel="nofollow - ComboChoosesRecord2k.zip
Access 97 (66 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/ComboChoosesRecord97.zip" rel="nofollow - ComboChoosesRecord97.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Replies:
Posted By: Roger Carlson
Date Posted: 17 Mar 2020 at 7:27pm
Access 2010-2019 accdb: ComboChoosesRecord_2010.zip

-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net