Unanswered: inserting a new linked record automatically on another form
I have 2 forms: Form A & B. They are separate forms, not subforms,
that are linked only by their Form# (which is an autonumber field in both forms). What I'd like to do is when a user creates a new record in Form A, that a corresponding new record is created in Form B automatically. I am not well-versed in VB. I'd appreciate any and all input. Thanks in advance!!!!!
I too have this error, having placed a duplicate record macro on a command button...
My table has many hundreds of records in it, what would be the consequences of changing the ID to something other than autonumber, and is it as easy as right clicking on the field and changing the property?
a] both forms pointing to the same record in the same table?
b] the second form to pointing to a duplicate record in another table?
c] the second form to pointing to a duplicate record in the same table?
What my user wants is a quick way of entering a record onto a form.
We thought we might be able to do this by adding a command button and assigning the "duplicate record" macro to it.
Once the record is duplicated she would just change the values in the relevant fields....
Thanks for your help...