changing data in a table being used as the data source for an open form

[Sarah]

Please could someone suggest a way of using VBA code to
delete a record from a table containing just one record
whilst the table is being used by an open form?

Basically I would like to replace the existing record with
a new record, either by deleting and appending to the
table or by updating the table as part of a routine.

The first thing I tried was using VBA code to run an
update query on the table in question, however because the
table is already open (as this is what the form uses for
it's source data) this would not work. I'd be really
grateful if anyone could suggest a way around this
problem, e.g. is it possible to lock or affect the
properties of a table such that it can be edited whilst
being used as the source for a form?

Many thanks.

 

[Bryan Reich [MSFT]]

What is the reason you are trying to edit the table's record "underneath"
the form so to speak? Why take this route as opposed to editing it through
the form? It might help us devise a solution if we have a little bit more
information surrounding the scenario you are trying to build and the purpose
for which it is going to be used.