Wrong list - try the user list not the discuss list. On 10/03/2016 08:56 AM, Robert Großkopf wrote: > Hi meakasteve, > > > > 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. > > Don't know how to get an event from the row-marker. But the following > code would work, if you will put it on the event "onclick" of a field > in the row you will change: > > Sub Main(oEvent) > oForm = oEvent.Source.Model.Parent.Parent > oForm.updateString(2, "new Text") > oForm.updateRow() > End Sub > > First row connects to the form of a field in the tablecontrol. Form is > parent of the tablecontrol, which is parent of the field. > Second row updates the second field (2) with the text "new Text". If > it isn't a string you want to update, you have to change the code here. > Third row will write the code into the table, which is connected to > the form. > This will only work for updating a row, not for inserting new data to > the row. > > Here some code from the German Handbook, which updates different fields: > ----------------------------------- > DIM unoDate AS NEW com.sun.star.util.Date > unoDate.Year = Year(Date) > unoDate.Month = Month(Date) > unoDate.Day = Day(Date) > oForm.updateDate(3, unoDate ) > oForm.updateString(4, "ein Text") > oForm.updateDouble(6, 3.14) > oForm.updateInt(7, 16) > oForm.updateRow() > ---------------------------------- > Updating a date is a bit tricky, because it has to be a special > variable, which defines day, month and year. > > Regards > > Robert >
-- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted