transferring inforamtion to a subform. ??with VBA

[paul]

Access 97 :
A form ( clients) with a subform (appointments) in data sheet view
Id like to to transfer the relevant information ( name address, tel no
etc) from the displayed 'client' record to the line of the subform that
Ive selected
1. Is the best way to do it with VBA?
2. How do i reference eg the fourth line of the datasheet view of the
subform.
? an array
3. Id like to transfer the appointment information ( eg time) back into
the main table writgin to a field in the 'client' table.
Any hints where to start ?

many thanks

 

[Estuardo]

-----Original Message-----
Access 97 :
A form ( clients) with a subform (appointments) in data sheet view
Id like to to transfer the relevant information ( name address, tel no
etc) from the displayed 'client' record to the line of the subform that
Ive selected
1. Is the best way to do it with VBA?
2. How do i reference eg the fourth line of the datasheet view of the
subform.
? an array
3. Id like to transfer the appointment information ( eg time) back into
the main table writgin to a field in the 'client' table.
Any hints where to start ?

many thanks

Paul:

I think this is not a good practice. I mean to duplicate
data in your tables. If you already have the customers
info in the main form (which i assume has its own
underlyig table) why would you need to repeat the info in
the table Appointmens, if you can do that with a query?
Following the order of your questions.
1. Yes. The only way to do such of thing is with VBA
(Please don't get me wrong, is not my intention to be
rude)
2. You don't need to reference any row.
Access just take one at a time. So the row where you are
is the active record. So there is no need to make any
reference to the row number or position (this is called
the Event model).
3.The same as my previous remark. Do not duplicate data.
there is no need to denormalize your tables.

good luck

Estuardo.