expression for a txt box on a form

  • Thread starter Thread starter mgm
  • Start date Start date
M

mgm

I've put an unbound text box on a form. I want this txt box to have a data
source from a table in the same database, but the table is different from
the forms. What is the expression to do this?
 
mgm said:
I've put an unbound text box on a form. I want this txt box to have a data
source from a table in the same database, but the table is different from
the forms. What is the expression to do this?
Click to expand...

Do you mean you just wish to display a record's field from a different
table.

=DLookUp("[FieldA]","TableName","[SomeIDField] = " & [SomeControl]")

The where clause above is problematical, as I have no idea what the
datatype is or even if you need criteria at all

Look up DLookUp and
Where clause + Restrict data to a subset of records
in Access help.
 
Back
Top