I want to open a specific form

[Don Croner]

Hi:

The data base (access 2003) I am creating will have 150 employee files in it. I want to open a form to edit employee information. ie, if employee john smith gets a pay raise i want to edit his form to change the data. I have been able to open the table using a macro but not the form. I am a total novice with access but I have been able to use the wizards to create the file. Any help you can offer will be greatly appreciated.

[MMcCarthy]

Hi:

The data base (access 2003) I am creating will have 150 employee files in it. I want to open a form to edit employee information. ie, if employee john smith gets a pay raise i want to edit his form to change the data. I have been able to open the table using a macro but not the form. I am a total novice with access but I have been able to use the wizards to create the file. Any help you can offer will be greatly appreciated.

Do you want the form to open on database startup or from another form?

Mary

[anukagni]

How much field your table have ... If your using less the 12 field the can us the sub-form to get the employee data and do the modification..

If so reply we will give the solution...

or go to this link to get some example to get the result

http://www.databasedev.co.uk/forms.html

[NeoPa]

Firstl, I would store each employee data in a single record each within a single table (files don't really come into it in a database).
Have you looked at the form wizard and creating a form based on that table?
You may find this will give you most of what you need.

[anukagni]

IF ur using only one table to store all the data's of the employee
then in an from put an combo box which lise on employees name the designation which ever you feel mandatory . Then create a query with the field which you want to edit or you can use all the fields and in the query give the expression [Forms]![your from]![your combo box] - Your combo box must be the last combo box whichi your using . if your using Employee Name & Designation then you have to use Designation in the query.. did u understand.

Then in the create an sub-from from the Query ..the save the table which ur going to modified... if ur not able to understand reply to us..


anuk agni

[anukagni]

hi,

Take a look the screen shot which iam using for editing inventory ..this form is using in intranet also..

http://anuk.about.tc/shot.jpg


anukagni

[Don Croner]

Thanks to all. I got it working using a combo box in the form. I doubt I will ever be an expert in MS Access but this forum is great and I have already learned a ton.

Thanks again, Don

[MMcCarthy]

Thanks to all. I got it working using a combo box in the form. I doubt I will ever be an expert in MS Access but this forum is great and I have already learned a ton.

Thanks again, Don

You're welcome Don.

Glad you got it working.

Mary

[anukagni]

well you have to ask lots of question , which will keep our mind refresh..
Don't think any question is worse every question make some one sharper

Keep your tempo hoist
have a nice day


anukagni

[NeoPa]

Never assume you won't master a subject.
Everything looks more complicated when you first start with it.
Come back and remind me of this after you've posted your first hundred :).