Using Record Selectors to transfer data between forms

[Guest]

Hi All,

I have a repair database where I have a product repair form and a spare
parts form.

I have fields on the repair form for PART_NUMBER, DESCRIPTION & PRICE.

I have the same fields on the spares form which is a datasheet view with
record selectors to the left of each row.

How can I program the click of the record selector or perhaps a "Transfer
Data" button using the selected record to transfer the required data from the
spares form to the repair form? Do I use a MACRO or what? Basically how do I
identify the selected record?

There may be a need to select multiple spares but at the moment I just need
to transfer one item at a time.

Any guidance how best to approach this would be greatfully received.


--
Cheers
Chas

***************
* Spectrum is Green *
***************

 

[Ron2005]

Just selecting the record would probably NOT be the best condition to
use because you could very, very easily select the wrong record. and
whenever the form is opened A record is selected. A button or a double
click on a form would be better.

A double click would simplify the action, because all of the fields for
that record are available through the me.xxxxx mechanism. If you use
the query wizard to create a append query, it can reference each of
those fields in the record you are sitting on.
If you write the sql to create the append sql you can use the me.xxxx
method

If the subform is in datasheet mode then the button has be be on the
form and it can still execute the query or a macro that executes that
query.
If the subform is in a single form mode than the me.xxxx mechanism or
the query or the macro method can be used.

 

[Guest]

Dear Ron,
Thanks for the advice, I just thought the record selector was an easy "built
in" function that would allow quick selection of a part.

I'll build the whole around double clicks as you suggest.
--
Cheers
Chas

***************
* Spectrum is Green *
***************