Master/Child Link to Subform

[PaulA]

Hi, all--

I have a subform in a data entry form in an Access97 db. For some reason, when I add a new record in the master form, I am not able to enter a record in the subform because a record can't be found in the subform with key matching fields.

This is correct because no records have been created. In the past, this has not been a problem. I would enter a record and the matching field would automatically generate the value linking it to the master form (in this case a customer number).

Also, I am told I "can't build a link between unbound forms" when I am in the links property area. The forms are both bound.

Any ideas why this isn't working?

Thanks!~

 

[monkeytunes]

Hey PaulA,

I'd start by double and triple checking that the fields that the child and master are linked by are named correctly. It's very common that, when you change the name of a table, a query, or a field in a table or query, that Access doesn't follow the whole chain of what is linked to what. Make sure you check the properties of the subform (NOT the Form Properties of that subform...see the difference?) and double-check those field names. If after checking it three times you didn't find it...check a fourth time. Work your way all the way back and make sure everything is named correctly - I only get this error message when I changed the name of something in a table or a query.

Barring that, check the relationships in your Relationships Window and double check any ad-hoc relationships in your related queries.

You might also just add the same subform again, link it, and see if it works.

Hope that helps!

 

[PaulA]

It turns out it had to do with the bound column of the master field.

Thanks for the input.