Form-Record Automation Problem

[keatsy_040489]

Greetings. I have 2 tables (named BusinessInfo and Details) which are properly linked with each other (1 to many relationship). The first table contains a date field [Date Added]. The second table contains 2 date fields namely: [Date Assessed] and [Date Inspected].



By definition, the 3 date fields may or may not be equal in value.

Thus, I am making a form that whatever I entered in the [Date Added] will automatically entered in the [Date Assessed] and [Date Inspected] but I have the capability to change [Date Assessed] and/or [Date Inspected] later.

The problem is I cannot get into it. Anyone who have the idea of doing what I am trying to achieve may be a great help. Thank you in advance. God bless.

[pdebaets]

Are you saying that if you entered a BusinessInfo record 2 years ago, then today you wanted to enter a Details record, you would want the default value of the Date Assessed and Date Inspected fields to be from 2 years ago?

Try setting the DefaultValue property of each date field to "=Date()". See how that works for you.

[keatsy_040489]

Are you saying that if you entered a BusinessInfo record 2 years ago, then today you wanted to enter a Details record, you would want the default value of the Date Assessed and Date Inspected fields to be from 2 years ago?

Try setting the DefaultValue property of each date field to "=Date()". See how that works for you.

Not exactly sir. I can only enter [Date Added] once.

The thing is if I enter record many years ago, that date I entered in the [Date Added] should be the same date in the [Date Assessed] and [Date Inspected] in the first record in my details table.

When I updated my Details table probably next year (That should appear in the 2nd record in my details table), [Date Assessed] is where I enter date in that year.

In this case, [Date Assessed] may or may not be equal in [Date Inspected]. That is why I want to automate [Date Assessed] and [Date Inspected] also. But later, I have the ability to alter [Date Inspected].

Anyway, thank you for the help sir. I'll give you my feedback later.