Records from a List Box

[gselliott]

I am wanting to be able to click on a record in a List Box and then display the relevent record info on a seperate form, is this possible??

Thanks in advance.

 

[Mile-O]

DoCmd.OpenForm "MyForm", acNormal, , "ValueID = " & Me.MyListBox.Column(0), acFormEdit, acDialog

 

[gselliott]

Thanks, works a treat!!!!!

Much Appreciated!

 

[MiAs]

Combo Box

Will this work for a combo box?
If so, can info be copied to another field within same form?

 

[Simplycongy]

Yeah, just post this into your after_update or on exit event

me!WhateverField.Value = Me!YourComboBox.Value