Continuous form with command buttons

[Brian]

I have a continuous form that has a command button on it. That button is
used to copy data from one field to another within that record. I am
wondering if there is a way to enable only the button for the current record,
while all other record's button are disabled?

 

[Bill]

Brian,

If the record selector is enabled, you can either
use your button or maybe double-click the
selector area to effect the field copies via the
event code. In either case, you'll need to capture
the "RecordID" and use something like a
RecordSet Clone to locate and perform the
copies in code.

Some of the MVP's might have a simpler
approach, but I know this approach will get
the job done properly.

Bill

 

[Linq Adams via AccessMonster.com]

Putting aside the question of copying data from one field in a record to
another field in the same record, what exactly is your point? You can, in
fact, only press the command button on the current record.

If you're on Record1, and click on the command button on Record3, Record3 is,
at that point, the current record, not Record1.

Am I missing something here?

 

[Bill]

Another way of saying what Linq is pointing out
is that whatever "line" (record) has the focus is
the record you're presumably wanting to work
with. With that, all you have to do is hit your
command button and in your code sheet you
can copy field to field,
Me.MyField2 = Me.MyField1, etc.
Bill