T
Tanya
Hi I have a form which I need the user to be able select individual students
from a drop down list, the table it is linked to is [students] and I have a
field [studentID] which I have run the following query for Row Source and it
is not working, is the problem that the form field may be edited?
SELECT DISTINCTROW Students.StudentFName & ", " & [studentLName] AS FullName
FROM Students ORDER BY Students.StudentFName & ", " & [studentLName];
My Goal:
I wish to be able to select from a dropdown box a students full name. I have
used the studentID field to run the row Source query but the following error,
hence I thought it might have something to do with the field being able to
directly edit the table [students]
**********The value you entered isn't valid for this field.**********
Any assistance/guidance in this matter would be greatly appreciated.
Kind Regards
Tanya
from a drop down list, the table it is linked to is [students] and I have a
field [studentID] which I have run the following query for Row Source and it
is not working, is the problem that the form field may be edited?
SELECT DISTINCTROW Students.StudentFName & ", " & [studentLName] AS FullName
FROM Students ORDER BY Students.StudentFName & ", " & [studentLName];
My Goal:
I wish to be able to select from a dropdown box a students full name. I have
used the studentID field to run the row Source query but the following error,
hence I thought it might have something to do with the field being able to
directly edit the table [students]
**********The value you entered isn't valid for this field.**********
Any assistance/guidance in this matter would be greatly appreciated.
Kind Regards
Tanya