question involving listbox, hyperlink, textbox

  • Thread starter Thread starter Boss
  • Start date Start date
B

Boss

On my form I have a listbox that uses the following sql

SELECT tblCards.PROJECT, tblCards.OLD_NAME, tblCards.PRIMARY,
tblCards.SECONDARY, tblCards.DISCIPLINE, tblCards.VENDOR_DWG,
tblCards.DRAWN_BY, tblCards.DWG_CREATE, tblCards.ORIGIN, tblCards.SIZE,
tblCards.DESCRIPT_1, tblCards.DESCRIPT_2, tblCards.DESCRIPT_3,
tblCards.NOTES_1, tblCards.NOTES_2, tblCards.FILE_NAME
FROM tblCards
WHERE (((tblCards.PROJECT) Like [Forms]![f_Search]![cmbProject]) AND
((tblCards.PRIMARY) Like [Forms]![f_Search]![cmbPrimary]) AND
((tblCards.SECONDARY) Like [Forms]![f_Search]![cmbSecondary]) AND
((tblCards.DISCIPLINE) Like [Forms]![f_Search]![cmbDiscipline]));

the FILE_NAME field is stored as hyperlinks, containing the path names
ie l:\ENG\Projects\etcetera

When the user clicks on one of the filtered records, I populate the
info from the listbox into text boxes but the hyperlink comes up
surrounded by the # symbol, i've tried changing ishyperlink setting to
true and false noticing no difference (not that I know what that exact
property does anyways...)

example: #O:\PROJECTS\FINISH\00000124.DWG#

and it's not a clickable link anymore. I don't actually have any bound
controls on my form, was wondering if there's a way to search the
drawing number and populate a bound text box with teh corresponding
hyperlink or if I should approach this from another angle. if more
information is needed please let me know. :D thankyou
 
Back
Top