Is this the correct SQL syntax for auto populating 4 rows in a .ACCDB 2007 field? When testing, it auto populates for a couple seconds, then Access freezes.
I'm modifying the original SQL in the Property Sheet -> Row Source that auto populates 3 columns (Last Name, First Name, Birthday):
Code:
SELECT [dbo_Person].[idPerson], [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
FROM dbo_Person
ORDER BY [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
To this in trying to add a 4th column that's just an ID number in the first column:
Code:
SELECT [dbo_TestData].[TestNum], [dbo_Person].[idPerson], [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
FROM dbo_TestData, dbo_Person
ORDER BY [dbo_TestData].[TestNum], [dbo_Person].[Last_Name], [dbo_Person].[First_Name], [dbo_Person].[Birth_Date]
[TestNum] will populate, but then after about 2 seconds it will freeze Access and not respond.
dBforums
>
Auto Fill Search Field
09-16-11, 17:59
Auto Fill Search Field
Try Join Example to using at your query
Linear Mode
