troubleshooting Question

link subform to a dummey field in the master form

Avatar of João serras-pereira
João serras-pereiraFlag for Portugal asked on
Microsoft AccessVBA
5 Comments1 Solution126 ViewsLast Modified:
Hi -
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?
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros