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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a continious sub form 2
Add Next Number To A Field from another Form 6
cant get cbo to stop outputting key# 0
Access Sub form opens before the main form in MS Access 0
Auto- Populate certain Fields 4
Creating a Sub-Form to record Sub-Projects 3
Delete an entry from a field 1
Access Form - Lock Fields from Editing 0

Back
Top