then click one from listbox show fault info in textbox

Fugan

Registered User.
Local time
Today, 17:19
Joined
Aug 7, 2006
Messages
16
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
 
Are you trying to populate a memo field with the value that is in your list box?
 
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.
 
yea i would do that but if someone adds new job u would have to add more code for every job
 

Users who are viewing this thread

Back
Top Bottom