Access 2000 Query!

[Confused_Case]

I have created a database which uses serveral tables etc, From the tables i have devised i have produced forms! This i no is pretty basic. The problem i am having is;

On a form, is it possible to click within a record so that when the record is selected you then simply click a command button, this should then display that specific records full list of details? For instance lets say there is a list of employees. They all have unique numbers. If for instance the second record is selected can u simply click on the command button so that you are then displayed with that employees full list of details?
cheers!

 

[stephen81]

Yes. Presumably you currently have a continuous form listing the employees.
You need to design another form (single form, not continuous) with all the details you want showing. Then all you need to do is add a command button to the detail section of your form to open your new form showing the new record. The Command Button Wizard will take you through that.

 

[Confused_Case]

yeah i have the other single form listing all of the employees details. But on the main form you'll have several records depending on the amount of employees invovled in that section. What i need it to do is that when say employee 2 is clicked or highlighted, you simply then click the full employees datils button and this should then display all of the employees details! I tried your idea but am puzzled as to what command i should select that will allow me to do this?

 

[Crilen007]

You need two forms, one will have the employee name and number.

The second will have the details.

You create the first form, then use the subform button to add the second one, into the main one, and then link them through the employee ID. then when someone selects another employee it automatically shows the information.

 

[Confused_Case]

Thanks alot mate! That worked great! yesssssss wooooohoooooooo