Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting a command to a specific record in a subform

Status
Not open for further replies.

leocarter

Programmer
Jul 8, 2003
16
US
I'm making a database for a clinic and I am not 100 % a programmer.
I want to put a command in a subform that shows OrderDetails records to open a form with details of OrderDetails that are specific for an specific record in OrderDetails. I did it but the command appears in every record of the subform. I think that with a phrase of code in the "on enter" condition I can set the command to appear only in the record I am needing it. May help me to do this?
 
Anything that shows in one row of a continuous form will display in every row. You might want to consider putting the command button in the Form Header or Footer. I often set a double-click event on one or all fields to open a detail form.

Duane
MS Access MVP
 
Thanks again dhookom, I put to work double click as you advised and goes perfect!
Thanks also to Bill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top