Hiding/Unhiding data on Forms

[tonym33]

Is it possible to create a form that pulls data from a table and changes based on data being entered? We do construction and as part of the process we track our estimates by activity. Every job is different. If I have a job where the manager picks out 5 of the 20 different items that we are going to do, can I create a form that will only show those 5 items so that they can compare what they estimated to what they actually did? Along with that I want to be able to do this per job so some jobs might have 5 tasks some might have 15 and I want the form to change based on whether an estimated cost was entered.

[June7]

This describes a many-to-many relationship. Need a table that saves records to define these associations. This is a 'junction' table.

tblJobActivities
JobID_FK
ActID_FK
EstCost
ActualCost