If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Sub form fields do not sync
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. |
#3
|
|||
|
|||
Sub form fields do not sync
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. |
Thread Tools | |
Display Modes | |
|
|