Sub form fields do not sync

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub form that links to an account number field in the main form.
The account number is a 10 digit number. The main form will display all of
the account numbers properly, but the sub form will only show the accounts
that start with 1. Once it hits an account number that starts with a 2 or
anything other that 1 #Error appears in the account number field of the sub
form.

Any ideas? I have already checked that the account number field is the same
field type in all forms and tables.
 
How are you linking the main form and subform?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks for responding Jeff. Turns out I missed syncing one of the field type
in one of the tables. All set now.

Scott
 
Back
Top