Form is not populated 1

[Dophia]

Hello Everyone;

I am stumped by this problem. I have used it on other forms, but for some reason it doesn't work on the current form.

I have two tables with the same field [Phone_Log], with a one to one relationship. I have both tables in a query and the problem is the form is not updated with the fields until after I close the form. When I open the form and enter the Phone_Log number, it should populate the fields with the data from the tblPhoneCalls, but it does not. Can anyone help? Sophia

SELECT tblBy_Law_Cases.Phone_Log, tblBy_Law_Cases.By_Law_CaseID, tblBy_Law_Cases.People_ID, tblPhoneCalls.Inquiry_date, tblPhoneCalls.Time_of_Inquiry, tblPhoneCalls.Communication_Type, tblPhoneCalls.Received_by, tblPhoneCalls.Message_for, tblPhoneCalls.Message_from, tblPhoneCalls.Home_Phone_No, tblPhoneCalls.Work_Phone_No, tblPhoneCalls.Cell_Phone_No, tblPhoneCalls.Nature_of_Call, tblPhoneCalls.Memo, tblPhoneCalls.Email_Address, tblPhoneCalls.Email_Details, tblPhoneCalls.Return_call, tblPhoneCalls.Will_stop_by, tblPhoneCalls.By_Law_Complaint, tblBy_Law_Cases.Complaint_Date, tblBy_Law_Cases.Complaint_Time, tblBy_Law_Cases.By_Law_Complaint, tblBy_Law_Cases.Status, tblBy_Law_Cases.Priority, tblBy_Law_Cases.Due_Date, tblBy_Law_Cases.Comments, tblBy_Law_Cases.Investigatiing_Officer, tblBy_Law_Cases.By_Law_Warning_Given, tblBy_Law_Cases.By_Law_Warning_Type, tblBy_Law_Cases.POA_Fine_Given, tblBy_Law_Cases.Date_Closed, tblPeople.People_ID, tblPeople.Last_Name, tblPeople.First_Name, tblPeople.Spouse_CommonLaw_Last_Name, tblPeople.Spouse_CommonLaw_First_Name, tblPeople.House_No, tblPeople.Street_Address, tblPeople.Street_Suffix, tblPeople.[N/S/E/W], tblPeople.Apartment_No, tblPeople.PO_Box, tblPeople.City, tblPeople.Province, tblPeople.Postal_Code, tblPeople.Home_Phone_No, tblPeople.Work_Phone_No, tblPeople.Cell_Phone_No, tblPeople.Pple_Flag, tblPeople.Pple_Flag_Reason
FROM tblPhoneCalls INNER JOIN (tblPeople INNER JOIN tblBy_Law_Cases ON tblPeople.People_ID = tblBy_Law_Cases.People_ID) ON tblPhoneCalls.Phone_Log = tblBy_Law_Cases.Phone_Log;

 

[dhookom]

Do you see any records when viewing the datasheet view of the form's record source?
Is the form set for Data Entry?
Does the form have anything in the Filter property?
"enter the Phone_Log number" suggests there is an unbound control used for searching. Are all of the controls bound to fields?

Duane
Hook'D on Access
MS Access MVP

 

[Dophia]

I think it had to do with the one to one relationship. I changed it to a subform and now it works. Thanks for the insight Duane.

Sophia