I need to do a function in VB which allows you to list the data of a field in the database in a DropDown.
Ihavetolistdatafromthe'EixoX'field(fromthefigureabove)inDropDown.Thequestionis:IneedtolistDBdatafromagivenID,forexampleID=1,whereIhavetosplitby','thanitisinthe'EixoX'field.
SofarI'vebeenabletodothefollowing:
Asyoucansee,itlistsallthelinesinthe'EixoX'field.
HowcanImakeitlistonlythefieldfromagivenID,havingtosplititscontentsanddisplayeachoneindividually?Forexample,forID=1wouldhavetodisplaythefollowing: