Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Command button on a tabular subform

Command button on a tabular subform

Command button on a tabular subform


I need to add a command button to a tabular subform.

Item No. Part Description Cost Command Button

When the user clicks on the command button it will open a form that is linked based on the item no. This will then display item information.

Is this possible and if so any ideas how to achieve it.

Kind Regards


RE: Command button on a tabular subform

Have you thought about double click on the record selector?

You can only grab details relating to the current record, the relevant record needs to have been selected before any button on a parent form can get any information.

If you created a continuous form, you would have a button against each record, which IMO looks ugly.

If you used the form double click event, then Me.ItemNo is always the relevant record and can then easily be used in the form open command as either a filter or OpenArgs value.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close