Results 1 to 8 of 8
  1. #1
    Devang777 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2014
    Posts
    4

    i want to make form which can be used as update form

    I am working on trainee management database in which i want to make one form which can be used as update form . as i type Trainee id it will fill all the static information like phone no address etc if available in database other wise do nothing

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Are you wanting to auto fill one form from another form or auto fill from one form? Here is an example of a Combo Box that would auto fill some criteria.


    Me.ShipCity = ShipZIPCode.Column(2)
    Me.ShipStateOrProvince = ShipZIPCode.Column(3)
    Me.Dirty = False
    Or if making one form equal another form; Was not sure if your working with bound controls or not.

    Forms![frmCompNotes]![TxtDescription] = Forms![frmCompanyInformation]![EmailMessage]

    HTH

  3. #3
    Devang777 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2014
    Posts
    4
    Quote Originally Posted by burrina View Post
    Are you wanting to auto fill one form from another form or auto fill from one form? Here is an example of a Combo Box that would auto fill some criteria.



    Or if making one form equal another form; Was not sure if your working with bound controls or not.




    HTH
    Thank you burrina for your help.
    I am new in access , I am not able understand what you want to tell.
    I am working in access 2003 .
    In my project I am using the basic form .
    I am sending my project
    Trainee_info is the table to store trainee information
    and
    trainee_info is Form...

    pls dowload file from here...
    https://www.dropbox.com/s/0adlsjpdlhjo9pb/Akrsp_New.mdb

  4. #4
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Sorry, I don't use third party sites. Upload to this site if you desire. All I really need to see is your form setup.

  5. #5
    Devang777 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2014
    Posts
    4
    Quote Originally Posted by burrina View Post
    Sorry, I don't use third party sites. Upload to this site if you desire. All I really need to see is your form setup.

    Akrsp_New1 - Copy.zip


    Please see my project ....

  6. #6
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Did you try what I suggested?

  7. #7
    Devang777 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2014
    Posts
    4
    I am not able understand how can i implement your suggestion

  8. #8
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    I no longer download peoples db's, it takes up my data usage. Maybe someone else can explain better. If you could explain better in plain English, maybe with table and form structure someone could help.

    Good Luck!

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

Similar Threads

  1. Replies: 15
    Last Post: 07-30-2014, 02:28 AM
  2. How to make the time update while in Form View
    By Md1271 in forum Programming
    Replies: 4
    Last Post: 10-01-2012, 08:06 AM
  3. Replies: 7
    Last Post: 09-21-2012, 11:09 AM
  4. How to make a button on a form update report
    By Enemee in forum Programming
    Replies: 1
    Last Post: 07-05-2011, 11:24 AM
  5. Replies: 0
    Last Post: 05-09-2010, 08:43 AM

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