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

  • Thread starter Thread starter m galvin
  • Start date Start date
M

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