Access Form

Can someone help me? I have two forms in Access 2000. On the main form, frmMain, I have a button that opens another secondary form, frmSub. I did not want to use a sub-form in the main form. I want to be able to click the button on the main form to bring up the information on frmSub. I don’t know how to link the two forms without using an actual sub-form. Can someone help me with the code? The button on the main form has code to open frmSub: DoCmd.openform “frmSub”, acnormal. Can code be added to this to link the “id” field between both forms? Both forms use the same query.

mab,

Yes, try:

DoCmd.openform “frmSub”, acnormal,,"ID =" & me.ID

NB if both forms use the same data source, make sure you save the record in fmMain before opening frmSub or you will lock yourself out!

I have a simlar problem where I have meny forms with buttons opening the next form. I need the ID to follow through from the first form. Only way I have been able to make this work somewhat so far is by setting the default Value in the next Forms ID as the Value in the previous ID. This does work but if you scroll with the mouse it opens a duplicate record.
Surely there is a simple way to do this.