hi guys. we are a human resources outsourcing firm. we deploy contractual employees to different companies. i am currently making a human resources database, which consists of our contractual employees' record, which includes their contract dates. i already did a form for their records and a subform for the contracts and it looked like this:

http://i114.photobucket.com/albums/n...16/subform.jpg

i am really a newbie to ms access and vba. i just want to know where can i add a data entry for the contract dates... i tried to type in one of the fields, but it won't allow me to...

if you need the actual database file, here is the link:

http://www.gigafiles.co.uk/files/636...2006-10-11.zip

thanks so much.. and i definitely appreciate the help...

Wow. That is the most interesting relationship map I have ever seen.

I think you need to base the main form off a single table, and then base the subform off a single table, and this will work.

The fact that each form is based off a very complicated query will prevent data entry from happening.

HTH

mmcdonal

Thanks for the reply.. =) why did you say that is interesting? =)

should i create new tables?

well, i have this query for the subform:

SELECT tblPosition.PositionName, tblContract.StartDateContract, tblContract.EndDateContract, tblCompany.CompanyName, tblDealer.DealerName, tblOutlet.OutletName
FROM (tblOutlet INNER JOIN (tblDealer INNER JOIN (tblCompany INNER JOIN tblPosition ON tblCompany.CompanyIDPK = tblPosition.CompanyIDFK) ON tblDealer.DealerIDPK = tblPosition.DealerIDFK) ON tblOutlet.OutletIDPK = tblPosition.OutletIDFK) INNER JOIN tblContract ON tblPosition.PositionIDPK = tblContract.PositionIDFK
WHERE (((tblContract.EmployeeIDFK)=[frmEmployee2].[EmployeeIDPK]));

but it doesn't work.. what could be the problem? hope to hear from you again.. sorry for the inconvenience...