Multiple entries in a form

[Xzibit7]

Say an item has one part number but many different subparts in a table. So the table has one part number inputed many times and different subparts listed. How would you get a form to show just the one part once and have all the subparts just listed under that. With no blank spaces or extra forms just a listing underneath.

 

[TheAceMan1]

How are ya Xzibit7 . . .

If you had a table of part numbers (one side) related to a table of subparts (many side), All you'd need is a mainform of part numbers with a subform of subparts . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[Xzibit7]

Hey AceMan1,

Yeah, I was thinking that but since it is in the same table I was thinking I could just adjust the properties or something in the form. Basically I just want everything to look seamless where the subparts are just listed under the main part with no border or change from the current background.

Thanks

 

[Xzibit7]

I have seen someone do this with no subform but I just cant figure out how it's done.

 

[Xzibit7]

Okay now I cannot get it to list even with a subform. I disabled all toolbars...It just lets me scroll to the next subpart with the mouse or arrowkeys ...I would like to be able to see them all at once....

 

[Xzibit7]

Ahh a list box is the key

 

[ProgramError]

It's a case of on the 'on update' event of first listbox, requery the second listbox.

The second listbox requires a query or SQL statement as its record source.
the query needs to filter out all sub partsnumber records with the same partnumber matching the contents of the first listbox.

You can format the second listbox without a border so it looks like a list as you wanted.


Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.