Hi thank you for the help but I am still a bit confused, I've tried and will insert below. I am still getting an error.Only use alphanumeric characters and underscores in names. When you put spaces in them (Exam ID), it makes you need an additional step when working with them. That step is surrounding the name in brackets. So put brackets around Exam ID in the Dlookup ([Exam ID]). Or better yet, fix all your names to comply with the rule above.
=Dlookup("Grade", "TblExam", "ExamID='" & Combo25 & "'")
Why is the Combobox Unbound ?Hi I am new to access and trying to include a Dlookup in my coursework but I can't seem to get it working, I keep getting #Error. Its just to lookup a value in a table. Any help appreciated!
Search form?Why is the Combobox Unbound ?
Normally the table would have a field named GradeID - Number datatype.
Then you would have a separate table that lists all of the Grades.
On your form you would create a Combobox and you would lookup the value you want from the Grades Table.
I have tried this and the error message is gone but it appears blankThat DLookup does not have a clue what Combo25 is. So:
=DLookUp("Grade","TblExam","[ExamID]=Forms![FORM NAME]![Combo25]")
I’ve tried this again and it’s worked!!! Thank you so much !!!I have tried this and the error message is gone but it appears blank
My teacher used this in his example, I don’t know much about it to be honest I’ve tried adding the column and it resulted in #ErrorAsk again, did you read post #6?