I tried that but it didnt work

I cant send you the database cause our information is confidential. I wish I could though :(

yeah but thats the tab control what about the subform??

Ok.
When you are using a main form and connecting records, the recordset in the subform is only those records related to the main form. So if you select an I/R on the main form, only those subjects related to that I/R are available on the sub form.

Make sense?

Kevin

dartcoach

yes I understand that. Should I just get rid of the subform then?

Since the subform has a tab control, you can only see one subject at a time correct?

dartcoach

yes the one pertaining to that I/R number

thanks again for your help on this

Desireemm,

If there are many subjects related to that I/R number, and you are trying to search those subjects, you should be able to do that, but without being able to see your database, it's difficult to figure out how to go about it. If you create another form, use the subjects table as the recordsource. Create a dropdown to search the subjects. Use your current subform as a subform on this new form. Once you get that to work, then, use the new form as a subform on the I/R form instead of the one you're using now. Does that make any sense?

Kevin

dartcoach

I guess creating an advanced search feature would be what I have to do. I just want to be able to search by more then just the mainform, but also the subform