copy record

[nelleh]

Hi,
I have a form ('A') for editing new records in table 'T' . I want to be able to copy data (just some fields) from another record to this new record.

This was my plan:
On this form 'A', I made a button "copy another" that opens a form 'B' that should show all the records from tabel 'T'. User select a record and then all the necessary fields will be copied to the new record in form 'A'.

However, the first error starts when I open this form 'B'. I get the errornumber 3211. The err description is (I have to translate because I have a dutch versoin). "The database engine can't lock the table 'T'. Table 'T' is in use at the moment by another user or proces".
How can I make this work? I understand that the table is in use, because form 'A' is using the same table.

greetings
Nelleh

 

[ShaneMan]

Hey Nelleh,

Take a look at this thread. I think it may be what your looking for or at least give you a good start in the right direction.

http://www.access-programmers.co.uk/forums/showthread.php?t=98170

HTH,
Shane

 

[nelleh]

Hi shane,

It is not exactly what I am looking for. In all these cases you start by copying a record to a new record.
In my case I am pointing at the new record and from that point I want to find another record from which I want to copy some fields. My first problem is how to select the record that I want to copy while I am in a form using the same table.

greetings
nelleh

 

[supercharge]

How about closing Form 'A' right after clicking a button to open form 'B'? This can be accomplished by running a macro, not within code of form 'A'. Then open form 'A' back up after clicking a button (or whatever) to copy record and paste.

Another alternative, disconnect form 'A' to table 'T', refresh form 'A', open form 'B', copy record, close form 'B', reconnect form 'A', refresh, paste record. Ah...too long.