On my app I need to show a list of records and, upon a record is selected, thus becoming the "current" record of the form I need to display the entire details.
The below screenshot demonstrates the sought output.
In order to implement this, I have a master form "mform" and 2 subforms, "sf1", with the list of records, so it is of type "continuous forms" and "sf2" containing the detailed info, of type "single form". "As such "mform" is unbound: the records are shown in SFI and their detail in SF2 - SF2 is bound t the master table from which SF1 records are displayed
My problem is that whenever a new current record in SF1 is selected, I should have a means of modifying the contents of SF2.
I have tried to link SF2 to a dummy field in MFORM containing the actual record key, but I am getting an error as ms/access thinks that the field name is a Parameter. Of course also I cannot bound the dummy field to the master table and bound MFORM to it - ms/access yields an error as it thinks that I am trying to modify the record key
what shall I do?
can anyone help?