1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

finding records within a database ....

Discussion in 'Business Applications' started by softspoken, Apr 23, 2010.

Thread Status:
Not open for further replies.
  1. softspoken

    softspoken Thread Starter

    Joined:
    Mar 22, 2010
    Messages:
    55
    Ok I have a form that multiple users use to key in data. I want the user to be able to find records that have already been keyed. They are able to do that now just by setting the "Data Entry" to NO in the properties but then you risk someone one accidentally typing over data in another record because the first record always shows.

    When I change that to Yes then my Search function doesnt work.... I hope that is enough for someone to understand my issue ...

    Help!!!

    (Access 2003 )
     
  2. softspoken

    softspoken Thread Starter

    Joined:
    Mar 22, 2010
    Messages:
    55
    I fixed it ... this is what I used

    new record in the On Load event.

    CODE
    Private Sub Form_Load()
    If Not Me.NewRecord Then
    DoCmd.RunCommand acCmdRecordsGoToNew
    End If
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/918821

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice