LinkMasterFields subform error

[jalle]

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 LinkMasterFields 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?

 

[jalle]

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...

 

[jalle]

Now this connection is lost again.


Plizz someone help me !!

 

[John Vinson]

When I try to add new record in subform I get error

"The LinkMasterFields property setting has produced this error: 'A
problem occurred
while Microsoft Office Access was communicating with the OLE server or
ActiveX
Control'"

What version of Access are you running? Do you have all current
Service Packs installed? Have you tried Compacting and Repairing the
database, or recreating the Form?

Check out the corruption FAQ at

http://www.granite.ab.ca/access/corruptmdbs.htm

for additional suggestions.

John W. Vinson[MVP]

 

[jalle]

Thank you for quick reply.

I have installed Access 2003 with SP2

I reinstalled Access, thne inported all my db objects to new database.
And that didn't help. Maybe problem could be that I had new Office 12 ,
but I uninstalled it before this error

Only if I create new Form/Subform with Wizard then it worked.
But after using it connection is loast again ?!??!

This is the picture of fields ID1 (primary) and GeneralijeID (foreign
key).
http://img475.imageshack.us/img475/4759/missingid5ku.gif

As you can see 1 is missing at form but not in a table new record !!!

Thanks in advance


Jasmin
MCP
www.BonusMoney.tk

 

[jalle]

Also I have noticed that combo search box is not working with that
form. I use it to search for record.

But thing is that it normaly works in another form.

So my conclusion is: something is really wrong with FORM or SUBFORM I
have there.

How should I recreate it or what to do with her ???

 

[jalle]

Also I have noticed that combo search box is not working with that
form. I use it to search for record.

But thing is that it normaly works in another form.

So my conclusion is: something is really wrong with FORM or SUBFORM I
have there.

How should I recreate it or what to do with that form???