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

[Devang777]

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

[burrina]

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

[Devang777]

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

[burrina]

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.

[Devang777]

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 ....

[burrina]

Did you try what I suggested?

[Devang777]

I am not able understand how can i implement your suggestion

[burrina]

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!