Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Autoform Tabular (access 97)

    I have a query which provides a group of IDs that can go for batch processing. I want to show list of these IDs along with a chechbox, so that user can select what all IDs go for batch processing and which ones don't.
    I am trying to use Autoform Tabular Form , its showing me all the records but I added a checkbox to the design of this form and if I check the checkbox for one record it automatically gets checked for all the records.
    How can I make it work?
    Or if any one has totally different approach for this problem?
    Any help will be appreciated.

    Thanks,

    Isha

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autoform Tabular (access 97)

    I would create a ID table, with 2 field , ID field and Yes/no field.
    Create a form in datasheet view and let the user check the yes/no field for the ID's he want.
    You could the make a query on you ID table Where Yes/No field = TRUE to retrieve the ID to process.

    Another approach would be a Multi select listbox with the ID's and process the selected ID's.
    Francois

  3. #3
    Lounger
    Join Date
    Jan 2002
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autoform Tabular (access 97)

    Thanks!
    Creating form in datasheet view is a fantastic idea.
    Thanks a lot for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •