We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How can one transmit data from one subform to another at the same or higher level? [closed]

asked 2014-09-17 09:49:39 +0200

PChitnis gravatar image

updated 2021-06-04 20:36:19 +0200

Alex Kemp gravatar image

In an application, with tree structured sub forms, I need to transfer data from a lower form to a higher form, to be subsequently used in another branch, something like a reversed master/slave connection. Say the main form "A" table has fields A1, A2, A3 and one sub form "B" table has field B1, B2, B3 etc with fields A1 and B1 as master slave. I wish to read data in B3 into A3. The purpose is to use this data in a sub form "C" which is parallel to "B". I cannot put "C" sub form under "B" as I need to use data A2 in "C" and it has no linked field in table "B".

I really hope I have made myself clear!

Prakash Chitnis

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-04 16:28:11.926712


I could work out the problem if I find out what is wrong with the following line in macro : "UPDATE ""unitedcghs"".""selecting"" SET ""integery"" = lastkwh WHERE ""id"" = 1" I get the message "Basic syntax error. Unexpected symbol: Update...... (command reproduced). I need to update one field in a file with a single record with data extracted from another file. The data is successfully retrieved but the above command does not work.

Or I find a way to run a MySQL Procedure instead of a macro!

PChitnis gravatar imagePChitnis ( 2014-09-28 13:32:24 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-10-01 18:14:53 +0200

PChitnis gravatar image

The version of MySQL I am using does not require the extra double quotes! "UPDATE unitedcghs.selecting SET integery = '"& lastkwh &"' WHERE id = 1" works! In the macro I get the value of field in one form using xxx.getby value() into lastkwh and then update the other file, followed by updaterow() and refresh().

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-09-17 09:49:39 +0200

Seen: 196 times

Last updated: Oct 01 '14