PLEASE HELP - Two tables populating one form

[intergnat1]

Hi Everyone,



I'm trying to have two text boxes in one form be populated by fields from two tables (field from table1 populate one textbox, field from table2 populate the other textbox). I've tried playing with "control source" for both and can only get one to populate correctly (I get "#Name?" in the other textbox when I type "[table2]![text2]").

As I can only assign one "Record Source" for the Form, I don't see how I can get around this problem and I don't know the access syntax well enough to properly research my issue I feel like this should be such an easy fix but I simply cannot find the solution. Can somebody please hold my hand a bit on this? Thanks!!!!!

[Stressed]

Do these tables have related fields?

You can build a query with the information that you require then use that query as the record source.

[MuskokaMad]

A little more detail would be helpful but in general.

1. Usually Tables contain many records so the two tables need to be related so that the form knows which record to look for in each table.
2. If the tables are related you can use a DLookup for the control source.

Syntax = DLookup("FieldName","TableName",Conditions)

eg. = DLookup("FirstName","tblCustomers","ID =" & Customer_ID)

In the above example the code will return the contents of the FirstName field in the Customer Table where the Primary Key ID is the same as the foreign key Customer_ID on the Parent Table.