Form doesn't allow update

  • Thread starter Thread starter Frankie via AccessMonster.com
  • Start date Start date
F

Frankie via AccessMonster.com

I have the following problem :
One table : tblProspects/Clients with One to many relationship
Two Queries : QueryProspects and QueryClients both linked to
tblprospects/clients
Two Forms : FrmProspects with queryprospects as record source and FrmClients
with queryclients as recordsource.
Whereas I can add and modify records thru FrmProspects to
tblprospects/Clients, I can not do the same thru FrmClients whose
queryClients is not updatable which I don't understand.
The principle behind this is to have Prospects records turned into Clients
records within tblprospects/clients thru a criteria (Prospects to Client)
changed as soon as another form is used and validated.
I would greatly appreciate some help on this one.
Thanks in advance

Frankie
 
Frankie

Check Access HELP on "updatable recordsets". It may be something as simple
as including a key field.
 
Back
Top