This problem was discussed before but it doesn't solve my situation
I have master table Generalije with PK: ID1
I added subdatasheet table Nalaz with field FK GeneralijeID
When I add new record to Nalaz directly in Table View then GeneralijeID
is regulary added as FK (same as ID in Nalaz) EVERYTHING IS OK HERE
When I try to add new record in subform I get error
"The LinkMasterField s property setting has produced this error: 'A
problem occurred
while Microsoft Office Access was communicating with the OLE server or
ActiveX
Control'"
Subform settings:
Link Child Fields . . . . . . . . . . GeneralijeID
Link Master Fields . . . . . . . . ID1
Problem is in form/subofr and not ina table/subdatasheet.
Can someone help please?
*************** *************** ****
Those are replies to myself :(
*************** *************** ****
This is really strange.
I recreated my form with subform using form wizard.
Everything works ok cause FK GeneralijeID is added normaly in new
record. Last record (new record) is now set to 1 just like AutoNumber
we see in PrimaryKey field
Huh sinceI couldn't repear my old form/subform but I'll modify this new
one...
*************** *************** *********
Now this connection is lost again.
Plizz someone help me !!
Reply
I have master table Generalije with PK: ID1
I added subdatasheet table Nalaz with field FK GeneralijeID
When I add new record to Nalaz directly in Table View then GeneralijeID
is regulary added as FK (same as ID in Nalaz) EVERYTHING IS OK HERE
When I try to add new record in subform I get error
"The LinkMasterField s property setting has produced this error: 'A
problem occurred
while Microsoft Office Access was communicating with the OLE server or
ActiveX
Control'"
Subform settings:
Link Child Fields . . . . . . . . . . GeneralijeID
Link Master Fields . . . . . . . . ID1
Problem is in form/subofr and not ina table/subdatasheet.
Can someone help please?
*************** *************** ****
Those are replies to myself :(
*************** *************** ****
This is really strange.
I recreated my form with subform using form wizard.
Everything works ok cause FK GeneralijeID is added normaly in new
record. Last record (new record) is now set to 1 just like AutoNumber
we see in PrimaryKey field
Huh sinceI couldn't repear my old form/subform but I'll modify this new
one...
*************** *************** *********
Now this connection is lost again.
Plizz someone help me !!
Reply
Comment