How to link form and subform

method · June 26th, 2005, 09:55 AM

Hi every body. i made a bounded data entry form that is based on a form and a sub form. But when i try to run it i get many errors. I be happy if some one help me how i link these two tables since draging the sub form to the form did not establish the reletion automatically! I be happy if some one teach me how to link form and sub form together. Below u can see the two query which is for the main form and sub form.thanks

http://i5.photobucket.com/albums/y18...constraint.jpg =====> table reletionships pic

QTimeKeepingemployeno,name ==>query

Code:

SELECT dbo_Employee.employeeno, [dbo_Employee]![lastname] AS EmpName
FROM dbo_Employee;

subform query:

[code]

SELECT dbo_Hours_worked.*, dbo_Task.description
FROM dbo_Hours_worked INNER JOIN dbo_Task ON dbo_Hours_worked.Task = dbo_Task.taskcode;

[/code}

AccessMaster · July 30th, 2005, 02:19 AM

On the property sheet for the sub form, on the data tag, set the master/child link properties.

If Access did not set then, then the relationship was not defined or the queries for the forms do not have the correct key fields.

Boyd
Access Based Accounting/Business Solutions developer.