Make table woes

Question posted by: Rob (Guest) on November 12th, 2005 04:41 PM

Hello,
I am having an application using A2K.In my subform ,I have 3
combos.Division,Group and Names.The Names are dependant on Division
and Group.But in some cases there are Names without groups.These Names
can be filtered by the Division.I have set up a table as a Rowsource
for the Name.I am having two make table queries.One for the Names that
have Division but no Groups and the other having both Division and
groups.Both these Queries make up the same table(The Rowsource).These
Queries are run on the afterupdate event of either Division or
Group.It works fine when i add a new entry.But when i try to edit an
existing names,(ie by changing either the division or the group or
both) ,i get an error saying that the table has been locked and no
changes can be made.How to make this workable so that edits can be
made?
Thanks for your help.

Rob

Quote | Subscribe