Displaying data from two different tables on one Form.

[Kolten]

I have a table that holds questionnaire data.
I have another table that holds event data.
Relationship is as follows:

tblQuestionnaire
QuestionnaireID
EventID
Address... etc

tblEvent
EventID
EnteredBy
DateTime
ClientLastName
ClientFirstName

The linking key is obviously EventID.

I have a form that displays all the Questionnaire data from the
Questionnaire table.
I want to place the DateTime from the Event table onto this form.

I cannot seem to figure out how to grab the DateTime record from the Event
table for the particular Questionnaire the user is currently viewing.

The DateTime fields also needs to be editable.

Is there a way to do this without getting into VB code?
Thanks.

 

[Gina Whipp]

Kolten,

You will need to create a query and then base your form off of that query OR
you could use a DLookUp on an unbound field on the said form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm