Filter Between Forms 1

[Basia]

Greetings. Can anyone tell me if there is a way to filter between forms with the following results?

Form 1 - currently on clientA record and want to see training data for ClientA by clicking on form button to open training data.

Form 2 - open training data for ClientA, but still have all other records on that form(recordset). ( Not just filtering to open that particular record)

So at the bottom of training data form it would say:
Record 3 of 28 (which is ClientA) instead of
Record 1 of 1 (filtered).

Does this make any sense?

Thanks,
Basia

 

[momon]

yeah i gotcha...
uh...
so you want to see all the training records, not just the specific one for ClientA.

there must be some identical data between form 1 and form 2 such as the CLIENT NAME.

Ok, uh... you have to write some code for this i think.
For form#2, click the OnLoad() event builder. Select the Code Builder.

Your code should look something like this.

Private Sub Form_Load()
DoCmd.GoToControl "Client Name"
DoCmd.FindRecord Forms![Form 1]![Client Name]
End Sub

 

[Basia]

It works! I actually put the code right after the Open Form cmd.

Many, many thanks!!!!
Basia