Copying Records

[DS]

How do you copy are field from one record to a new record on the same
form using code?
Thanks
DS

 

[Guest]

Hi DS:

You need to be a bit more specific. If I where to right code I would need
to know why are you copying, and what you want to copy. There are many
different ways to do what you ask. A better definition of what you are
doing, would allow me to give you a more specific answer or at least point
you in the right direction.

 

[M.L. Sco Scofield]

See the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210236.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[DS]

Hi DS:

You need to be a bit more specific. If I where to right code I would need
to know why are you copying, and what you want to copy. There are many
different ways to do what you ask. A better definition of what you are
doing, would allow me to give you a more specific answer or at least point
you in the right direction.

:

I have a field on a subform that is called [LineID]...everytime I make a
new record it advances by one. But this is only the case when I choose
an item from Listbox1. Whenever I choose an item from Listbox2 I want
the new record to copy the LineID from the current record. Is this any
clearer? Thanks
DS

 

[DS]

Hi DS:

You need to be a bit more specific. If I where to right code I would
need to know why are you copying, and what you want to copy. There
are many different ways to do what you ask. A better definition of
what you are doing, would allow me to give you a more specific answer
or at least point you in the right direction.

:

I have a field on a subform that is called [LineID]...everytime I make a
new record it advances by one. But this is only the case when I choose
an item from Listbox1. Whenever I choose an item from Listbox2 I want
the new record to copy the LineID from the current record. Is this any
clearer? Thanks
DS

Found the Solution, I put a hidden field on the form that I open and
retai the value there, Once again Thank You, everyone.
DS