then click one from listbox show fault info in textbox

[Fugan]

hi, i have list box and the source coming form Query. i want when i click on
one in list box want it will show [faults] field in textbox from query
the field [faults] is a memo can someone help me
__________________
David

 

[Pete666]

Are you trying to populate a memo field with the value that is in your list box?

 

[Pete666]

You can always try something similar to below:

If Me.listbox = "test1" Then
Me.Comments.Value = Me.Comments & " test1"
Else
If Me.listbox = "test2" Then
Me.Comments.Value = Me.Comments & " test2"
End If
End If


You can obviously extend this to as many as is in your list box.

 

[Fugan]

yea i would do that but if someone adds new job u would have to add more code for every job