[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

Access Parse textbox values to ComboBox

I have a master detail form with a master text field parent.apps which contains text seperated by semicolons: data1;data2;data3;data4

I'd like to create a combo box in the detail subform child.apps which allow selection of the same datastrings: data1;data2;data3;data4

Is this possible?
Newb
0
tstreamer
Asked:
tstreamer
1 Solution
 
wsh2Commented:
For an unbound combobox.. try this..

   MySubForm!MyUnboundComboBox.Source = MyMasterForm!TextBox.Value

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can refer to the Parent of a Subform like this:

Me.parent.Property_Or_Control

So if you want your subform's Combo to show the same selections, do something like this:

Me.YourCombo.RowSource = Me.parent.ParentComboBox.RowSource

Or, from the Parent, in the Load or Open event:

Me.YourSubformCONTROL.Form.SubFormComboBox.RowSource = Me.ParentComboBox.RowSource

0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now