Quote:
Originally Posted by jayo17
Hi
i want to make a form that edits information on the table. the way i want it to be is on the first form have cascading combo boxes (which i have done already) and when the selection is made (which would be a person's employee number), i want to open another form with his/her information it derived from the table. then you could edit it and save the changes upoon review.
i can figure out the combo boxes, like i said, to filter to a specific person, but how can i link the 2 forms and have the second form's text boxes have the data already retrieved?
jay
Create that form which is bound to the same table of this form where you have the filtering functions.
one it is created, add a command button on your form (with the combo boxes), this command button should open the form for editing while looking up a specific record. There is a built in function wizard for this.
add that command ubtton using the wizard and choose form functions. there is a sub choice there that says something like open form and go to specific record. then it would ask you for more information.
