DB Search / Retrieval using TextBox/Grid

[tjbvo]

Greetings

Would someone please assist me with the following :

I have a database called HRM.

The database has three components , namely : -

1. Courses. This contains a list of all available courses.
2. Members. This contains al the personal particulars of the members.
3. CrsAtt. This contains a list of which member has
attended which course (s).

I have main three forms, as follows : -

1. frmCourses. This form is used to populate a listbox on the frmCrsAtt. This form is also used to add / delete
courses to the list of courses.
2. frmMembers. This form is used to add / modify / update / delete members. It also contains their personal info.
3. frmCrsAtt. This form is used to say which member
has attended which course (s).

This is where my problem lies.

I have added a form called frmSearch.

On this form I have the following controls : -

1. CmdSearch.
2. TxtSearch.
3. DAO control. (Data1)
4. Grid. (MSFlexGrid)

I need the code to use the txtSearch, actibated by the cmdSearch, to search the Database and return the result (Members particulars and courses attended) to the grid.

The txtSearch will only be used by the members work number,
which is unique to each member.

I would really appreciate it if someone would be willing to assist me.


Also am I using the correct controls ??????
Thanks in advance