×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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

List box and switching between records

List box and switching between records

List box and switching between records

(OP)
I'm working with Lotus Approach version 9.7 and need a bit of help.

I want to have a list box that displays the contents of a paticular field from a table to corespond to a number of field boxes on the same form. i.e. so when i click on one of the entries on list box the corresponding details for that entry will appear in the field boxes. I can't figure out which Macro to use for this or the correct options for it.

Cheers

RE: List box and switching between records

You need to create a variable field, named vID say, of the same data type as the database field. Put it on the form and make it a listbox, with list created from the database field.

Create a named find that finds on the listbox selection. In Browse, from the menu, Create | Named Find/Sort | New | View. Click in the "real" id field and enter:

=@vID

as the find condition. Hit Enter, type a name for the find and OK out.

The named find can be run from the macro find command. It may be better to attach the macro to a button for the user to click after making the selection. The data change event doesn't fire until the listbox loses focus or the user presses Enter which is less intuitive than clicking a button.

Paul Bent
Northwind IT Systems
http://www.northwindit.co.uk

RE: List box and switching between records

(OP)
Thanks for that, i'll give it a try in work tomorrow.

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