Solved

Form/Subform reference not working

Posted on 2011-09-14
1
295 Views
Last Modified: 2012-05-12
I have a Form/Subform combo with a dropdown box on my form that references a column of a table.  In the subform, when the user selects the value on the form, I want that same value to show in a textbox (or a dropdown) in my subform.  

I tried making the rowsource [Forms]![Form2]![Combo1] but this seems to do nothing.  Please help.

Thanks
0
Comment
Question by:--TripWire--
1 Comment
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 36537169

Unless you refresh or requery that control or the subform in the AfterUpdate event, nothing will happen in the subform.

The other method would be to use the AfterUpdate event of the main form combo to push the data to the subform control, like:

Private Sub combo1_AfterUpdate

    me!subformcontrolname!form.textboxname = me.combo1

End Sub
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now