Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 February 21st, 2005, 05:22 PM
Authorized User
 
Join Date: Jan 2005
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default Make the default value change

Hello Everyone,
I have two tables:
Table1: ProjectID, ActivityID, ActivityDescription, PercentComplete
Table2: ProjectID, ProjectDesc

Bascially this database is a one to many relationship where for every project you can have many activities. When I create an Activity I want to be able to have the textbox with PercentComplete to hold the default value as the max from the activities for that project. The acctual form works through comboboxes where I pick a manager and then projects for that manager show up. Then for that activity I can fill in information. The form runs of a query already. I need help with setting the textbox "txtPercent" so that when the Project is choosen in the drop down list the textbox automatically populates with the max number.

THanks for any help, I can provide more info if necessary






Similar Threads
Thread Thread Starter Forum Replies Last Post
Change default newsletter settings vantoko BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 March 28th, 2008 03:19 AM
make html button default sansircar ASP.NET 1.0 and 1.1 Professional 1 October 23rd, 2006 04:25 PM
make DW 2004 my default editor for ASP/JavaScript crmpicco Dreamweaver (all versions) 2 October 24th, 2005 11:40 AM
How can I change the default namespace allanhu BOOK: ASP.NET Website Programming Problem-Design-Solution 1 November 1st, 2004 01:15 PM
How to change the default printer donrafeal Pro VB 6 4 April 27th, 2004 11:28 AM





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