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