Get value from other tables 1

[Tom123456]

Hello
How do I get a value from another table. Example if I have a table mapped to a form then I can just write:

Dim test = [column]

But if the column is in another table, how do I do?, or can I mapped more than one table to one form??



- Tom

 

[Norris68]

If you want to pull a value from another form you can use:

MyValue = Forms("FormName").FieldName

If you want to pull a value from a table, use the DLookup function:

MyValue = DLookup("FieldName","TableName","FieldValue=" & ValueToLookUp)

(Third parameter is optional and allows you to specify the criteria - like a WHERE clause without the keyword)

 

[Tom123456]

Thanks Norris68!!!!!

I have tried to solve this for days...



- Tom