Database Help

[mccrimmon]

I have decided to go with bound forms due to the nature of the data and everything seems to be working fine, however, I was wondering if anyone could help with a few things.




On my form frmAddActivity, I want it so that when I click on page 2 the First Profile Due Date and Second Profile Due Date textboxes are updated if the Activity Type is a launch. These dates are calculated in query uvw_Activities. How do I go about achieving this?


My second question is......on form frmViewActivity I want to have it so that when an Activity Reference is selected all the associated funds with that Activity Reference (stored in ActivityFunds table) are populated in the subform as read only. Any suggestions on how to achieve this?

Example database attached.

[June7]

It is possible with coding to make one form serve for both editing and viewing data.

You can use a DLookup or include the query in the form's record source. Use an IIf expression in the textbox to display the value if Launch is Activity Type.

I tried to open uvw_Activities and get datatype mismatch error. Syntax for the DateAdd is wrong. Should be:
DateAdd("d",[tier1],[activitydate])
DateAdd("d",[tier2],[activitydate])
Day is default when calculating dates so this also works:
[tier2]+[activitydate]

Need to set the Data Entry property to No. Set the AllowEdits property to No on the main form or the subform Or use code to set this property.