Can someone knowledgeable in programming macros for Base help me?
I have a form (Form A) which displays data as a data-sheet. This form also
contains a button. When this button is pressed it activates a macros which
opens another form (Form B) in the databank. That bit I can do.
What I cannot do is this: I want first to highlight a row in the data-sheet
of Form A by clicking the mouse onto the blank cell at the left-hand side of
the chosen row, then when I press the button I want the macro not only to
open the Form B but also to send data held in one of the fields of the
highlighted row of Form A (the field contains primary key) to Form B.
More explicitly: The data-sheet in Form A contains a list of customers and their addresses, I select a particular customer from the data-sheet by clicking on it with the mouse. Base then highlights the row and marks it with a little green cursor (all done automatically - no macro required!) I then click on the press-button which activates the micro and this should open Form B which contains further details about the customer I marked in Form A such as what purchases he/she has made in the past. As my macro currently contains no code to pick up the data in the highlighted row, the wrong customer appears when Form B is opened.
If anyone can tell me the script that I need to do this I would be most