PARTIAL display of recordset in form

  • Thread starter Thread starter sfrvn
  • Start date Start date
S

sfrvn

Good day, all...

I offer the following as the 'weird one of the day'!

I have a form with a 5-tab TAB control. The form is 'bound' to a large
query (5 tables with average 20 fields per table). Each/every control
on each of the 5 tab/pages are bound to one and only one
query/recordset field -- generally, each tab page corresponds to one of
the tables. The query returns exactly what I expect to see in the
recordset.

All is fine, EXCEPT the data returned by the query from ONE of the
tables is not visible in the form's controls. I have confirmed that
the controls are 'bound' AND executing the query shows the data in the
datasheet. If I bind one of the offending controls to a field (similar
data type) derived from another table in the query design, the data IS
displayed.

I've searched the newsgroups, but can find nothing similar to this
problem. Most searches turn up only references to simple binding
issues. I'm stumped...

Summary:
Multi-tabbed form bound to qryAll (all fields from tables #1 to #5)
data derived (through query) from table 1 is displayed on tab/page 1
data derived (through query) from table 2 isdisplayed on tab/page 2
** data derived (through query) from table 3 is NOT displayed on
tab/page 3 **
data derived (through query) from table 4 is displayed on tab/page 4
data derived (through query) from table 5 is displayed on tab/page 5

I would be thankful for any ideas... thanks a bunch!

gary b
 
For any of you thinking about an answer to this problem, thank you.
After making the post, I packed up the office... intent on downing a
few pints! When I opened a copy of the database on my home computer,
it worked fine... all tabs!

The problem, well... disappeared. The only thing I did between the
'not working' state and 'working' state was close the database and
reopen a copy of it at home. <scratching head>

Anyway, thanks for the bandwidth...

gary b
 
Back
Top