Help with add button on foms

[lushh]

hi.. i am currently having a problem with the add button on my "frmEmployee2". once the button is clicked, a message "you can't go to a specified record" appears. what seems to be the problem? any advice is welcome and would definitely be appreciated. thanks in advance. attached is the copy of the ms access file.

 

[boblarson]

Get rid of the link between tblEmployee.PositionIDFK and tblPosition.PositionIDPK. You are linked to it twice ... once through tblContract and once directly. That won't work. Once I removed the link specified, it worked just fine.

 

[lushh]

thanks for the reply.. where will i remove the link? in Tools>relationships or in a specific query only? sorry i am really new to this. thanks so much...

 

[boblarson]

It was the query that your form is based on.

 

[lushh]

hi.. sorry for the late reply.. i was quite busy.. yup! it did work perfectly.. thanks a lot.. i owe you one.. =) but there is a problem with the combo boxes in the same form.. i can't select from the items in the combo boxes.. why is that so?