I have a relational database with a main form and a subform. And my problem is I cant search on the subform part. I cant use the Find feature on the subform I created the find record from the wizard and it works great on the main form but on the subform I cant get it to search anything. It will only Find Records on the Subform.

Help??

Desireemm,

What exactly are you trying to find on the subform? Do you have a parent - child relationship between the main form and the sub-form? I. E. Employee info on the main form and dependents on the subform?

Kevin

dartcoach

yes there is a child relationship. the subform is on a tabcontrol. the subform has names of subjects I need to search by. The main form is the Investigators findings and the subform is the subjects involved in the findings (usually theres more then one)

When you say the main form is the Investigators findings, is there something you are searching on the main to get to those findings? Then, the sub-form - is all the data on the tab control (regardless of which tab) coming from 1 table?

Kevin

dartcoach

no theres two tables. the main form has a I/R number that you use to search the findings that number is unique and the primary key in the mian form (Reports_table)

seems as though by default you cant use the Find Record on a subform which is on a tabcontrol. Is there a way to override that, some code or something??

So the second table contains all the information about the findings and is related to the first table by the I/R number?


dartcoach

yes

one I/R number can have more then one subject and the subjects information

Desireemm,

How big is your database? Can you zip it up and send it to me?
A tab control is like a field on a form. You can adjust the tab control size, and put another dropdown on top of it to search the records.

Kevin

dartcoach