Parsing values and extracting secondary values

[quicksilver1024]

Passing values and extracting secondary values

Hi,

Is it possible to have a single combo box who's value will be passed into every subsequent entry of a record?

If you take a look at the attached picture, you can see a combo box for Machine. I want to push this value I select from the drop-down onto all of the Problems below. I have made a hidden field for each Problem that will hold the Machine and Machine category.

Also, each Machine has an attached Machine ID that (Machine ID) points to a Machine Category. How can I make the Machine Category of the selected Machine from the combo box appear in the list box the the right of it?

Any help is appreciated.

 

[Bilbo_Baggins_Esq]

In general, all of what you want is possible, but I can't seem to locate any attachment.

There are numerous possibilities, but I'd like to see your image first.

 

[quicksilver1024]

Hi Bilbo,

I forgot to attach it the first time I posted. I guess it takes a while to load the changes.

Here's the pic: http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=18172&d=1185287683

 

[quicksilver1024]

Doing this:

Private Sub MACHINE_NAME_COMBO_AfterUpdate()
Me.MACHINE_CATEGORY_COMBO.Requery
Me.MACHINE_NAME_COMBO = Me.MACHINE_NAME_INVIS
End Sub

Will only allow me to pass the value from the combo box on to whatever Problem I am focused on. The value should be passed to all entries of the subform.

 

[quicksilver1024]

Here is the table for the Machine Category and its subform (Machine Name)

 

[quicksilver1024]

Can anyone help?

Essentially, the problem is passing values from one combo box on to all fields in the subform...