Multiple field copy

C

Chuck

I would like to copy a series of unbound controls (up to 6, actual data
value from Table A) from one control to another field on the same form.
Instead doing this one at a time copy and pasting, i would like to do this
through a command button (or better automation) when pressed will copy
contents of all controls on left side of form from (Table A) to like
controls/fields on left side of form (Table B). The two tables are not
linked and dont have any relationship. Not great at using VBA so other
solutions preferred.
 
J

JK

Chuck hi,

You would need to program Access in some way to accomplish that. If you
don't wish to use VBA, the only other way is to write macros - use the
"SetValue" command in this case.

Regards/JK



|I would like to copy a series of unbound controls (up to 6, actual data
| value from Table A) from one control to another field on the same form.
| Instead doing this one at a time copy and pasting, i would like to do this
| through a command button (or better automation) when pressed will copy
| contents of all controls on left side of form from (Table A) to like
| controls/fields on left side of form (Table B). The two tables are not
| linked and dont have any relationship. Not great at using VBA so other
| solutions preferred.
 
C

Chuck

any suggestions on VBA code example?
I guess i would set value of the field in table B = to value in table A and
keep repeating this in the macro?
 
J

JK

Hi Chuck,

Assuming all contros are on the one form you would use the OnClick event of
the Command button to attach a macro with consecutive SetValue.

in VBA you attach an event procedure:

Private Sub YourButtonName_Click()
Me.BoundControlName1=something1
Me.BoundControlName2=something2
Me.BoundControlName3=something3
Me.BoundControlName4=something4
'etc
End Sub

Apology for the late reply

Regards/Jacob



| any suggestions on VBA code example?
| I guess i would set value of the field in table B = to value in table A
and
| keep repeating this in the macro?
|
| "JK" wrote:
|
| > Chuck hi,
| >
| > You would need to program Access in some way to accomplish that. If you
| > don't wish to use VBA, the only other way is to write macros - use the
| > "SetValue" command in this case.
| >
| > Regards/JK
| >
| >
| >
| > | > |I would like to copy a series of unbound controls (up to 6, actual
data
| > | value from Table A) from one control to another field on the same
form.
| > | Instead doing this one at a time copy and pasting, i would like to do
this
| > | through a command button (or better automation) when pressed will copy
| > | contents of all controls on left side of form from (Table A) to like
| > | controls/fields on left side of form (Table B). The two tables are
not
| > | linked and dont have any relationship. Not great at using VBA so other
| > | solutions preferred.
| >
| >
| >
 
Top