Help with Form

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

Guest

I have a continuos form as a subform.
Is there anyway I can get selected fields in the last row of the subform to
appear on the main form.

Is this even possible.
Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9340-84f7d1211734&dg=microsoft.public.access
 
The issue with this is - which row of the subform do you want the data to
come from? Not that you have a real choice. I just wanted you to think
about the question. In any event of the subform, you can copy the value of
a field from the CURRENT subform record to a field on the main form. You
can place your code in the subform's Current event if you always want the
main form to show a value from the current record as you click into it or
you could do it in the subform's AfterUpdate event if you wanted the main
form to show the last updated value. Of course since you shouldn't be
actually storing data from the child recordset in the parent record, the
main form field would be empty if you choose this option until someone
actually updates a record in the subform.

If you can offer more details regarding why you would want to show a value
from ONE record of the many-side of a relationship in a view of the one-side
record someone may be able to offer a more specific solution.
 
Back
Top