getting info from subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform and I need to get the primary key off of the selected
subform. I want to do something like: Forms![main form]![Subform]![key]. The
only exception is that the key is not displayed on the subform. I know if you
say something like [key] it will get the key off of the selected record. How
do I do this for a subform.
 
The right syntax will be
Forms![main form name]![Subform name].Form[key]
And if you have a problem. then add the field to the form and change the
visible property of the field to false.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Data Entry Setting 0
Subform record coordination 2
Parameter Value error in a Subform 0
primary key - concatenated or autonumber? 6
Access Main form/Subform Navigation 0
Copy records from Subform A to Subform B 2
Query/Report Output Based on Current Record in a Form 3
mirror data from subform to main form 3

Back
Top