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!

*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

button on existing field

button on existing field

button on existing field

Scenario   2 files     1) PROBLEMS   2) CUSTBANK
The ID# field in Problems requires that it already be in the ID# field in Custbank.    If the ID# in Problems is not already in Custbank, I want CUSTBANK to open automatically by using the 'button feature' so I can enter the ID# and related info.  I do not know how to write a formula to make this happen.   Any help would be greatly appreciated.
Replies continue below

Recommended for you

RE: button on existing field


  You could a button on your entry layout that would allow a user to enter a new customer. Just have the "new customer" button open a layout that references the CustBank table (with the appropriate fields on it). The user can then enter the new customer in the Custbank table.
  I usually just minimize the calling database (when I open the data entry form) and return to it upon close of the data entry layout.


Dr Tree

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! Already a Member? Login

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