query problems

[gersheff]

Hi eveyone. this is my first time here.

Here is what i am trying to do, and it is obviously giving me problems. For all those who know the Assets Tracking database which is a template in Access, I am trying to do something very similar to when you click on the "Maintenance..." button in the "Assets" form.

I want a new form to pop up, which will be directly related to that previous form. This second form is already created.

I hope i am clear and make sense. A speedy response would be greatly appreciated.

 

[pbaldy]

I'm not familiar with that template. If by "related" you mean the second form will open to the record currently selected on the first form, look at the wherecondition argument of DoCmd.OpenForm. It will do that for you.

 

[gersheff]

I will try and be more specific here. I actually want to do 2 different things.
The first form will include information about A. At the bottom of the page, the user will be given a chance to create a sub-list. (eg. A= information about a sports team, at the bottom of the page the user will want to add the player names). So 1 bottom will be used to open the second form and the user will be able to modify all the players that have alerady been entered into the system. A second button will give the user the opportunity to enter new players.

We also want the title "A" (or team name) to appear on the top of form #2.