F
FA
Hi, I have a search text box where user enters a string and it click
the search botton and it looks into a field called FINDG_NME in a table
called STD_FINDG. This table has the default static data which never
changes.The results of the search are presented in another form.
I have another form called frmFinding which is based on table FINDG. it
has the combo box which has the DLookup code behind it and it looks up
the selected finding name from the STD_FINDG table and populate the
rest of the fields from that table to FINDG table. Now user wants to be
able to type the string and get the results and want to pick a result
and they want to populate that recordset into FINDG table in
frmFinding. frmFinding remains open during all this operation.
Following are the steps that user takes:
1- Open frmFinding -- which is based on table FINDG
2- Type in search textbox and click the search command button
3- It looks up that string in table STD_FINDG in field called FINDG_NME
and all the finding names are presented to user which has that string
that they typed in the search textbox.
4- Now user wants to select one finding name and insert into the
frmFinding with the rest of the recordset.
5- If it is based on the same table, its easy to do it i could just use
the linkcriteria, but its two different table.
How do i achieve this task, if someone has any suggestions and
recommendation, i would really appreciate it.
thanks
the search botton and it looks into a field called FINDG_NME in a table
called STD_FINDG. This table has the default static data which never
changes.The results of the search are presented in another form.
I have another form called frmFinding which is based on table FINDG. it
has the combo box which has the DLookup code behind it and it looks up
the selected finding name from the STD_FINDG table and populate the
rest of the fields from that table to FINDG table. Now user wants to be
able to type the string and get the results and want to pick a result
and they want to populate that recordset into FINDG table in
frmFinding. frmFinding remains open during all this operation.
Following are the steps that user takes:
1- Open frmFinding -- which is based on table FINDG
2- Type in search textbox and click the search command button
3- It looks up that string in table STD_FINDG in field called FINDG_NME
and all the finding names are presented to user which has that string
that they typed in the search textbox.
4- Now user wants to select one finding name and insert into the
frmFinding with the rest of the recordset.
5- If it is based on the same table, its easy to do it i could just use
the linkcriteria, but its two different table.
How do i achieve this task, if someone has any suggestions and
recommendation, i would really appreciate it.
thanks