N
nigel
I have two tables of data that i want to match visually. I've created
a Master Form showing a single record from table 1, and a subform
showing multiple records from table 2. I have a series of buttons
which match different fields (eg Postcode Sector, City, Phone area
code, first letter of the name etc) on the master and subform to help
identify likely matches.
My code takes the form
Me![subform].[LinkMasterFields] = [table1 City]
Me![subform].LinkChildFields = [table2 city]
When i run the code i get a 'data type mismatch error'
What am i doing wrong?
a Master Form showing a single record from table 1, and a subform
showing multiple records from table 2. I have a series of buttons
which match different fields (eg Postcode Sector, City, Phone area
code, first letter of the name etc) on the master and subform to help
identify likely matches.
My code takes the form
Me![subform].[LinkMasterFields] = [table1 City]
Me![subform].LinkChildFields = [table2 city]
When i run the code i get a 'data type mismatch error'
What am i doing wrong?