Results 1 to 3 of 3
  1. #1
    johnyx is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2014
    Posts
    2

    Form opening problem

    Hello everyone !! I 'm using the 2007 version ,where i have created a small database.I 've also created a form including the tables.
    I searched around the net and i didn't found anything that can possibly help me.The "problem" is ...When i open the form ,it shows the first record.. but ..i want it to show default values on the boxes.I know that it can be done through VBA ,but i can't find more related details.
    I would appreciate it if u can help me !!!

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Default Values appear in a New Record; is that what you want to do, open the Form to a New Record? If so the code would be

    Code:
    Private Sub Form_Load()
      DoCmd.GoToRecord , , acNewRec
    End Sub

    If you only want to use this Form to enter New Records (not being able to view/edit existing Records) you could simply set the Data Entry Property to Yes.

    Linq ;0)>

  3. #3
    johnyx is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2014
    Posts
    2
    Hey Linq , thanks for your reply ! though this is not what i exactly want to have in my form.I want to use it as a typical form,to view and format my data ,and I also want it to have blank textpoxes, in all the form, while opening ..

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

Similar Threads

  1. Replies: 29
    Last Post: 01-29-2014, 01:04 PM
  2. Problem with opening the database
    By sk88 in forum Access
    Replies: 4
    Last Post: 03-01-2012, 01:33 PM
  3. Problem While Opening DataBase.
    By cap.zadi in forum Access
    Replies: 2
    Last Post: 12-13-2011, 08:34 AM
  4. problem opening .mdb file
    By honeybee in forum Access
    Replies: 7
    Last Post: 06-25-2010, 11:33 AM
  5. Opening Form in Data Entry Mode Problem
    By alsoto in forum Forms
    Replies: 1
    Last Post: 05-28-2009, 07:45 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