Recent content by PresleyKSU

Actually I figured it out. I removed the Link Child and Master Fields and it works fine. I've never ran into that before. My brain must've taken a vacation day without me knowing. Thanks for your patience, Rolliee.

Thanks for helping out, though.

3000+

Right and that's the problem. Even if I make the RowSource = the table that is associated with (i.e. tblSearch) it will still only give 2 or three records.

The RowSource is "frmCompanySub" which is the name of the subform.

Why wouldn't all the data from a table show up in a subform if the subform and mainform are pointing to that specific table? Example: I have a Main Search form. Once the user enters criteria thru combo boxes, a new "pop-up" form appears. During this process, I have a query that...

Very Close. Right([fieldname], Len([fieldname])-InStr(1,[fieldname],">",0)) Thanks, tempclerk. Much appreciated. PresleyKSU

I'm trying to cut off the beginning portion of a string. Here's where things get fuzzy. The beginning portion is seperated between < and >. The length of this portion varies so I cannot do a &quot;Len(blah)-5&quot; thing. i.e. 1.) <----blah, blah----> Real Data 2.) <--------BLAH...