LinkMasterField issue

[Walle]

I cant get the two command buttons at the top to work apart from the Find Record button. And when you go to select a option from the drop down, this message comes up and I don’t know what it means.

I have attached a screenshot to show what I mean.

[pbaldy]

It appears to have a problem with the master/child link properties of the subform control. I'd double check those.

[tanvi]

Before Someday ago, I also suffered with this error. I had a query underlying the form which used the tbl.* to query all the fields in the table and then tbl.field which was sorted ascending. I was trying to link my subform to tbl.field, but Access counted two instances of the field and could not decide which one to link to.

I used the Query Design window to remove the tbl.* part of the query and simply dragged in all the individual fields. The problem solved without having to create a separate text box.