Results 1 to 2 of 2

Thread: [RESOLVED] me.recordet - is not bringing in record data (access 03)

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    2

    Resolved [RESOLVED] me.recordet - is not bringing in record data (access 03)

    I have a form that is intended to allow a user to update only certain aspects of the record set, and it has been quite a while since I have done this....

    I do have a working one of these to go by - but am needing to make a new database - and fields have been modified, and for some reason - no matter how many times i cut and paste the original code - and modify the field names... it just won't work.

    basically what I am trying to do is allow the user to enter an inventory # in the 1st box on the form - when they hit enter the rest of the record's data should appear - if there is any -

    I have

    a combo box for this particular field - which is called Inventory

    in the properties of said box
    Data Row Source Type is Table/Query
    Data Row Source SELECT [tblInventory].[Inventory]FROM [tblInventory]; (when i save the form the brackets go away..?)
    Bound column 1
    Limit to List Yes
    Auto Expand Yes
    Enabled Yes
    Locked No

    the events are:
    Before Update [Event Procedure] but nothing coded
    After Update [Event Procedure] coded as follows:
    Code:
    Private Sub Inventory__AfterUpdate()
        ' Find the record that matches the control.
        Dim rs As Object
    
        Set rs = Me.Recordset.Clone
        rs.FindFirst "[Inventory] = " & Str(Nz(Me![Inventory], 0))
        If Not rs.EOF Then Me.Bookmark = rs.Bookmark
    End Sub


    what am i missing?
    please help i know office 2003 is not the "preferred" version - but this is for a customer and that is what they have.

  2. #2

    Thread Starter
    New Member
    Join Date
    Feb 2012
    Posts
    2

    Re: me.recordet - is not bringing in record data (access 03)

    found it - I had data entry option in the form properties set to yes!

    thanks for looking

Posting Permissions

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



Click Here to Expand Forum to Full Width