Select Record Commond Button

J

Jessica

I have a form with clientid Lastname firstname (cLIENTS fORM). in this form i
have a select record commond button. wHEN I CLICK ON THIS BUTTON I WANT IT TO
OPEN THE dATA ENTRY FORM WITH THE CLIENTS ENTIRE INFORMATION. wHAT CODE DO I
NEED IN ORDER TO DO THIS
 
L

Larry Linson

Jessica said:
I have a form with clientid Lastname firstname (cLIENTS fORM). in this form
i
have a select record commond button. wHEN I CLICK ON THIS BUTTON I WANT IT
TO
OPEN THE dATA ENTRY FORM WITH THE CLIENTS ENTIRE INFORMATION. wHAT CODE DO
I
NEED IN ORDER TO DO THIS
Click to expand...

You didn't need to SHOUT.

The Command Button Wizard will lead you by the hand through what you need to
do. In the dialog that offers you the choice, click the radio button that
says "Open the form and find specific data to display". Then follow the
prompts... you will, of course, need to have created the other Form -- the
one that shows all the Client's information.

Give it a try and post back here if you run into stumbling blocks.

Larry Linson
Microsoft Access MVP
 
D

David C. Holley

Use DoCmd.OpenForm and set the WHERE statement to [fieldName] =
Me.[fieldName] where the Me.[fieldName] refers to the field on the form
that contains the KEY of the record to display.
 
B

bernie

Oh come on now. This guy was not shouting, he was only not aware that he had
the caps Lock on. Looks like the German Knowledge base, where a lot of
wisecracking is done.
 
Top