Problems with Subform on TabControl

[Bob Newingham]

Access 2003 - I have a

• multi-user database with a front & back end.
• Table 1 and Table 2 with a 1 to Many relationship
  
  
  
  • Table 1 is the '1' / Table 2 is the Many
  • The relationship is based on an autonumber field 'client#'
  • Table 2 has a default value set for each field
  
  
• Main form bound to Table 1
• Subform on Tabcontrol bound to Table 2
  
  • Subform consists of 7 dropdown boxes
  • Each field is autopopulated from the table BUT
    
    • the dropdown is linked to a table with choices
    
    
  
  

Everything normally works fine...but on occasion-(with no rhyme or reason that I can discern) as I scroll through the records I will land on a record and the fields in the subform will be blank (When I know the linked table contains data, and the dropdown does not show any choices.
If I scroll to the next record it might be OK...but when I go back to the previous record...Issue is still there. If I close the database and reopen - everything works fine...THis is driving me crazy - Any thoughts or guidance

[RuralGuy]

It sounds like you are dealing with a screen updating issue. Are you using Lookup Fields by chance? http://www.mvps.org/access/lookupfields.htm

[thhui]

Could you post your db in mdb 2000 format for testing?

[Bob Newingham]

It sounds like you are dealing with a screen updating issue. Are you using Lookup Fields by chance? http://www.mvps.org/access/lookupfields.htm

The table is not using look-up fields - BUT the fields on the sub-form are using look-up fields that are linked to a table that contains choices for the fields. I read Evils of Lookup Fields in Tables...but am not sure how to solve the problem.

[RuralGuy]

ComboBoxes on forms that do Lookup's is fine, just not at the table level: http://www.btabdevelopment.com/ts/removelookups

[Bob Newingham]

I have double checked the the look-ups are at the form level...Any other thoughts as to what my problem might be?

[RuralGuy]

Can you reliably create the issue on a specific record?

[Bob Newingham]

that is part of my problem in tracking this down...it only happens occasionally and on different records...

[RuralGuy]

I'm out of ideas short of looking at the actual system. Even then as you say it is not predictable then tracking it down could be tough. A troubleshooting technique might be to Debug.Print the LinkChildField and LinkMasterField and maybe you will see why the SubForm is blank. That usually means no corresponding match in those two fields.

[Bob Newingham]

Thanks for the input...I will close this for now...will continue to look for patterns of behavior in the database....Maybe I will find something that will finally make sense...