schedule updating.

[Guest]

i am trying to create a form that displays a schedule of events in a
construction project. each event has an item number. each event has a
pre-task number, which is actually a reference to another item number on the
list. the start date of an item is the day after it's pre-task end date. i
need to make the calculation by referring to another record on the same list
with the criteria being the pre-task item number, and keep the dates current
as changes are being made. i have done this in excell and it is relatively
easy, but i want to do my work through access and create a databse system for
various reasons. i have created the table with the item list, forms to
display all the records, and even a form to update one record at a time, with
a subform to display the related pre-task info. but i cannot get it to work
on a form set to continuous forms.
i have thought of referring to a hidden form, no luck there. and i am
thinking i need to refer to a recordset clone, but don't know how.
i am not a beginner with access, but not an expert either. (novice maybe)
help!!!!!!!!!

 

[Guest]

Hi David,

Having worked on many construction sites as a Survey Crew Party Chief I
understand the importance of events being scheduled in a particular order.

However I find it difficult to understand what it is you want other than
some calculation to work on a continuous form. Can you be more specific?
Can you list your tables and fields like this and then explain in detail what
you want to acheive?

Example:

TableName1
FieldName1 Data Type (Text, Long Integer, Date/Time, etc.) Primary
Key Field
FieldName2 Data Type

TableName2
FieldName1 Data Type Primary Key Field
FieldName2 Data Type
FieldName3 Data Type

Please explain in more detail what is the calculation you want to make.

Continuous Forms do have some limitations so we need to know more details so
you can get the help you need.

Regards,
Hunter 57