I'm pretty new to databases and I was wondering if somebody could help me with something. I have a DBList in Form6 which reads from a Data control in Form6. The DBList contains all the Names of people which are male (It has got this information from the Data control). Now, when you click on a name in the DBList it brings up all the other information about the person, this information goes into some labels.
In Form8 I have a few Text boxes, and a command button. I want 1 text box to contain the Name of the person who is currently selected in the DBList another to contain the NickName of the person selected and another one to contain the HomeTown of the person. Could anyone tell me how to do that?
The next thing I need help with is editing the selected record. What I want to do is edit the information in the Text boxes in Form8 and then, when I press a command button I want the record that is selected in the DBList in Form6 to update.
If you could help me I would be very grateful.
Thanks in advance.