Why is this not a valid default value? =[timeline]![propertyavai]

[Ellsun]

I would like to see the date from the timeline table (propertyavai field) in
a field of another table, so I was trying to set the default value so I
wouldn't have to reenter the inof again. But it tells me it can't find the
field.

 

[Duane Hookom]

You can't reference another field in the default property of a field in a
table. But, that's ok since you should be entering data in forms where you
can include code to set values.

I assume you have a good reason for entering the same value in two different
fields.

 

[Ellsun]

Well, yeah, I guess I have a good reason. When I include the timeline table
in the query for a report, the report doesn't work. (The timeline is a
subform of property info form.) So that was the real problem. I figured if I
had to have the info in two different tables, maybe one would just
automatically populate with the data in the timeline table.

 

[Duane Hookom]

Any place you need the timeline table, you should be able to use a query
that links to your info table so you would have all the fields you need
without duplicating.