Passing form data to report

[ZOR]

If I have a table where one field contains data such as "Dog,Chicken,Bear" or "Fish,Cow,Pig" How can I fill a listbox from the table where only the first part of the data up to the comma gets added to my list?
Many thanks

 

[SgtJarrow]

Have a look at the Left, Right, Mid and InStr Functions.

Something lik

Left(field, Instr(0, field, ",") - 1)

should get you started

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer