The main form doesn't show any fields? What does it show? Where is this
left and right to which you refer?

It would help to know something of your database design and structure. Also,
post the command button code.

If you have Contacts and Contributions you should have a table for each,
related by ContactID (one contact, several contributions). With a main form
based on the Contacts table and a subform based on the Contributions table
there is no need to open another form. Rather, you can make the subform
visible or not as needed. If you wish to use a separate form for
Contributions you still need it to be related to the Contact table.

MTSmith wrote:
I've made a command button with the wizard to open a related form from the
main form. Ex: On the contact main form, push a button to see all their
contributions. The wizard asks which form to open, I say the Contributions
Form, then it says to match the ID field. However, the Main form listed on
the left has no fields listed. The one on the right lists all the fields for
the Contributions. Why does the Main form not show any fields?

Terry Smith

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200911/1