Help - How to add field from another table into form?

  • Thread starter Thread starter mau
  • Start date Start date
M

mau

Hi,

Ive created a form based on fields with from 2 tables, however i woul
like to add another field from a query i made, how do i do this? Othe
than creating a new form from scratch i cant find a way of adding thi
in

Thanks

Davi
 
As long as it is a non-updateable field, use DLOOKUP.
Me.FieldName = DLOOKUP("Column","Table/Query","Criteria")
 
Hi,

Ive created a form based on fields with from 2 tables, however i would
like to add another field from a query i made, how do i do this? Other
than creating a new form from scratch i cant find a way of adding this
in
Click to expand...

How is the form's recordsource related to the query? If the query
returns multiple records, how can you determine which of the records
to show on the form?

You can probably use the DLookUp() function to return a value from the
query, but just how you would do so depends on the questions above.
 
Back
Top