Select Record Commond Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
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.
 
Back
Top