Show data from multiple records?

[Jackmac]

Hi there,

Hopefully an easy one for someone. I'm writing a small app (Visual Studio
2008) which will take an existing access database we have and show it in a
form I'm writing. The fields have say customer and their files info. Record
1 could have customer name, the file box number, contents of file box. As
they are big boxes, the 'file box number' field contains duplicates - Box
123 contains 35 different files. I want, when the user clicks the 'file box
number' button on the interface I'm writing to show the data in the
'contents of file box' in a list view. It would sort of like a filter to
show data 'if 'contents of file box' = 'file box number'. That make sense?
Roughly, when they click Box 123, the listview box (if that's the control to
use) would show 35 entries. Any help very much appreciated.

TIA

Jack

[Jason Keats]

Jackmac wrote:

Hi there,

Hopefully an easy one for someone. I'm writing a small app (Visual Studio
2008) which will take an existing access database we have and show it in a
form I'm writing. The fields have say customer and their files info. Record
1 could have customer name, the file box number, contents of file box. As
they are big boxes, the 'file box number' field contains duplicates - Box
123 contains 35 different files. I want, when the user clicks the 'file box
number' button on the interface I'm writing to show the data in the
'contents of file box' in a list view. It would sort of like a filter to
show data 'if 'contents of file box' = 'file box number'. That make sense?
Roughly, when they click Box 123, the listview box (if that's the control to
use) would show 35 entries. Any help very much appreciated.

This group is for Visual Basic up to VB6.

If you're interested in later versions of Visual Basic, then use a
dotnet group, such as: microsoft.public.dotnet.languages.vb
Also try:
http://msdn.microsoft.com/en-us/library/aa187917.aspx
http://msdn.microsoft.com/en-au/beginner/default.aspx

The "Forms over Data Video Series" here
http://msdn.microsoft.com/en-us/vbas...=topsectionimg
is probably what you want.