Results 1 to 2 of 2

Thread: Unbound forms

  1. #1
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87

    Unanswered: Unbound forms

    Hi

    I've read the following post but what I would like to be able to do is to populate the form with a specific record (usually after completing a search form a search form). I've tried using the following code:

    me.txtintcase = recs!intcase
    etc.

    but it only every seem to select the first record, any suggestions?

    All help appreciated.

  2. #2
    Join Date
    Feb 2004
    Posts
    142
    In the AfterUpdate event in the combobox control (I assume you are using a lookup list) use the following code;
    Me.RecordsetClone.FindFirst "[CLAFieldName] = " & Me![controlName]
    Me.Bookmark = Me.RecordsetClone.Bookmark
    This usually works.
    KC

Posting Permissions

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