Results 1 to 3 of 3
  1. #1
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    Record appear if been entered before

    Hi,
    friend see attached file,this for update info,with two form main and sub form,i will update with info below first name second name.

    in case one name been entered before :example


    Bill jonhy been entered before when i re-enter it windows appear this been enter before u want to see it and open that info.
    till now i hqave solve it my problem the info in sub form not appear.

    see attched file,

  2. #2
    ashwin09 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    9
    If I understood correctly what you want , that would be to not display the previous records on the form. To do so , add a macro to the on-load properties of the form; that macro would be Go to record > New

  3. #3
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    i want to display diplicate record

    hi,
    as i mean in case person his info been entered before like
    person first name AA and second name bb
    when i am update again same info windows appear that info were entered before and show his info again


    thx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Date Record Entered
    By MikeDBMan in forum Access
    Replies: 6
    Last Post: 08-01-2011, 03:59 PM
  2. Replies: 1
    Last Post: 07-17-2011, 09:02 PM
  3. Using value entered as query criteria
    By morganba in forum Access
    Replies: 3
    Last Post: 08-11-2010, 05:52 PM
  4. Replies: 1
    Last Post: 09-19-2009, 09:37 AM
  5. Replies: 0
    Last Post: 11-10-2008, 12:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums