Can't build a link between unbound forms

[Boz]

This is the error message I get when I try to link the LogID (primary) from
the master form and the LogID from the Item Entry subform in the properties
box.

Both LogID's are Long Integers, with only the master table having the LogID
listed as primary.

I am using Access 97. I can build the exact same tables and forms in Access
2000 and it works, no problem. Unfortunately, everyone else in the office
the will be entering data has Access 97.

BTW--ignore my last post (Ok, I fixed one problem, now I have another). I
get the feeling that the two problems are related.
Help please.

 

[Barry Gilbert]

I'm not sure if this is the fix, but you might try typing the field names in
manually rather than using the subform link-builder wizard thingy. It's been
known to misbehave.

Barry

 

[Boz]

Tried that....no go. I also tried changing the recordset from Dynaset to
Dynaset (Inconsistent Updates)....still no go.

I don't know if this makes a difference, but in A2000, when I double click
on the subform in design mode I get a form design embedded in the master
form. I was able to click on the properties for the subform from there and
link the forms. In A97 I do not get the form design thing.

 

[Barry Gilbert]

Tried that....no go. I also tried changing the recordset from Dynaset to
Dynaset (Inconsistent Updates)....still no go.

I don't know if this makes a difference, but in A2000, when I double click
on the subform in design mode I get a form design embedded in the master
form. I was able to click on the properties for the subform from there and
link the forms. In A97 I do not get the form design thing.

That's unrelated. That was a change from 97 to 2000. I wonder if one of the
forms is corrupt. You can easily rebuild a form by creating a new one and
copying all the controls from the old one, all except the subform control;
create a new one of those. Other than that suggestion, I'm stumped.

Barry

 

[Albert D. Kallal]

I assume that you mean you "start" out as un-bound. Since, how would link
master/child settings apply to forms that don't have data????

You are correct however, that setting the sql of the sub-form will cause
problems. The fix/workaround is right after your set the sql, do the
following

Me.frmItineraryView.LinkMasterFields = ""
Me.frmItineraryView.LinkChildFields = ""