Paramter query, subforms and VBA...???

[aweizd]

Hi,

I have a database with a form to view the record. In this form, besides the records data, I also want to show a list of other record which are related to the current record (they have the same GroupID).

Now I was thinking of using a parameter query to find the records, but I don't know how to pass the GroupID paramter to that query, without bothering the user for input. It should be possible with VBA, right?

My next problem would be displaying the list. Since I never know how many records could have the same GroupID. As far as I know, you can't really create new text boxes using VBA to display the info, is that true? What would you suggest I do here? Maybe a subform? Never really used those before, but i can try it out.

I'd be really grateful if somebody could help me out...

Thanx in advance
Luke

 

[tkpstock]

You might want to take a walk through the Northwind.mdb database - it's the sample database that comes with Access.

There is a sample form in there that links a subform to a dropdown list - use that as your guide.