filling a field in a continuous form with a field from a table

[m galvin]

I have a form with the fields: date, client, atty, time, billable and
description. All these fields update the Time Sheet Table.

I want the atty field to automatically take the attorney's name from the
table Attorney which contains one field called Atty.

So for I can only figure out how to use a combo box to chose the Attorney
table field.

 

[Duane Hookom]

You could set the default value of the control using DLookup().
=DLookup("Atty","tblAttorney")
This could be a locked combo box that displays whatever value you want or
can derive from tblAttorney.