Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004

    Unanswered: Displaying records..

    I have designed a form through wizard.

    After selecting one of the fields 'Id': (Primary key)

    RightClick=>Change to=>ComboBox.

    Row source type: Table/query
    Row source: item
    ..(Under Data property sheet)

    'Id' combo box carries all the entered values. Can you suggest me a way that whenever i select a value from Id combo, the rest of the entries of the selected combo Id value be displayed automatically in their respective fields.

    And in case that id does not exist , it allows adding new data into the fields.

    I started by implementing AfterUpdate() Event. but still thinking about how to move cursor to the record, filling 'in the respective fields, and simultaneously allow addition/update features in the same form.

    Any help - Thanks in advance
    Last edited by hotspot; 02-25-04 at 12:59.

Posting Permissions

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