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

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
 
F

fofa

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

John Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
Finding the right style field in VBA 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Data entry for a table from a form 2
Data entry to table from a form 0
Add Field from Query to Form - Access 2007 7
Can a form linked to an autoLookup query update another table 1
Adding a field from another table on a form 2

Top