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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
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.
 
Back
Top