Sub form fields do not sync

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

"Smarti" wrote in message
...
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.

Thanks for responding Jeff. Turns out I missed syncing one of the field type
in one of the tables. All set now.

Scott

"Jeff Boyce" wrote:

How are you linking the main form and subform?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Smarti" wrote in message
...
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.