Adding records to unbound subform

  • Thread starter Thread starter JEB
  • Start date Start date
J

JEB

I'm using a main form with listbox to look up field selections from a master
table of patient values and using that value (in this case it is the
patient's location). I want to use a subform to display all the patients on
that ward and allow entry of a new record in another table
(tblClientTXEvents) for each patient through the subform, but I want to
programmaticaly add each record to the subform with the nonchanging
information already updated in the subform. The problem: I can't figure out
how to add these records to the unbound subform. I can do it using a
temporary table and then appending the newly created records to the correct
table, but that locks up the process for a second user while the first user
is updating, because the temporary table can't be deleted while it is open.
Can I do this without using a temporay table for the recordset? I apologize
for the lack of brevity. Thanks in advance.
 
JEB,
Split the database into a front end and a back end.
Each user has their own copy of the frontend, they share the same backend
where the data is stored.
Put the temp table in the front end, each user gets their own temp table and
the table in the backend is only locked for the instant that the update is
written to disk.

Jeanette Cunningham
 
Back
Top