Form change button?

[Romper]

Hi all,
Is it possible to create a button that will take you to a second form that brings up the same record. Form example, you have FRM_Alpha open and enter a certain amount of data and then click the button to open FRM_Bravo at the same record number to enter the second half of the data.

Please say yes, and tell me how!

 

[RuralGuy]

See if this link help a bit: http://www.baldyweb.com/wherecondition.htm

 

[Romper]

Thanks very much, that looks like just the thing!

It means I'm going to have to venture into unknown territory such as DoCmd & WhereCondition but I'll give it a go.

Thank you.

 

[RuralGuy]

Just post back to this thread if you run into a wall.