Subform Doesn't Contain All Data From Table

[PresleyKSU]

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 popoulates a new table named tblSearch with the search results. Withing this new "pop-up" form, I have a subform and all the Child links are set to the "pop-up" form. The subform should be pulling the results from the tblSearch but for unknown reasons it's only pulling the first few of 1000 or more records.

Any ideas? I know this is a Bass Ackwards approach to this but that's the way the Boss Man wants it.

 

[Rolliee]

Show us the RowSOurce for the subform for us to answer that.

Rollie E

 

[PresleyKSU]

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

 

[Rolliee]

The rowosource of a form is a table or query - if it is a bound form.

Rollie E

 

[PresleyKSU]

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.

 

[Rolliee]

How many records are in the table when you open it manually?


Rollie E

 

[PresleyKSU]

3000+

 

[Rolliee]

Hard to believe....

rollioe@bwsys.net

 

[PresleyKSU]

Thanks for helping out, though.

 

[Rolliee]

If you would like me to look at your file, send a zipped copy to rollie@bwsys.net

 

[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.