Yes the primary ID field is autonumber and the ID fields in the related tables are numeric long.
Which properties are you suggesting I remove values from. There are form properties, subform properties, section properties, field properties.
The name of the linking fields on the subform tables is 'ID'. What do you mean by removing the values from the properties?
I have written some VBA code but am not an expert by any means.
I have a data entry form with 2 subforms based on a master table and 2 many to one tables. THe key field on the master table is an autonumber field called ID. I have added ID fields as long int on the related tables. These fields are linked as master and child on the subform properties. I am...
I have a data entry form with 2 subforms based on a master table and 2 many to one tables. THe key field on the master table is an autonumber field called ID. I have added ID fields as long int on the related tables. How can I populated the ID fields on the related tables when added on the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.