DLookup not working for form

[ndehhh]

Hi guys, I'm new to Access here!



I've got 4 tables, Students, Courses, Course_Section and Registration.

I've created a form based off Registration and am trying to get the details (Last_Name, First_Name, etc.) found in table "Students" to autofill when I key in the "Students" primary key, Student_ID.

This is what I have:

Option Compare Database

Private Sub Student_ID_AfterUpdate()


PopulateFields

End Sub


Private Sub PopulateFields()


[Last Name] = DLookup("[Last Name]", "Students", "Student_ID = " & Me.Student_ID)
[First Name] = DLookup("[First Name]", "Students", "Student_ID = " & Me.Student_ID)
[Email Address] = DLookup("[Email Address]", "Students", "Student_ID = " & Me.Student_ID)
[Telephone] = DLookup("[Telephone]", "Students", "Student_ID = " & Me.Student_ID)

End Sub

Autofill works, but I keep getting 'You must enter a value in the 'Students.Last_Name' field', and I've no idea why.

Much thanks!

[RuralGuy]

Have you tried using a JOIN instead?

[ssanfu]

You keep typing "Last_Name" - with an underscore,
but your code has "[Last Name]" - with a space. So which is it?


BTW, shouldn't use spaces in object names....

[ndehhh]

Hi sorry it is "Last Name" without an underscore! What's the rationale for not using spaces in object names?

I now have this problem where DLookup only autofills the details for Student ID 1, no matter what Student ID I input into the form.
Also, when I click the button to register for course, the details do not appear in the empty "Registration" table even though my form's record source is selected as "Registration" and "Data Entry" under data is Yes

My button's code is as follows:

If Me.Dirty Then Me.Dirty = False

Any ideas?

[InsuranceGuy]

Check to see if your control [Last Name] is linked to the [Last_Name] field you intended. That error is suggestive that your table-level requirements for "not blank" are not being satisfied. If you have text in your control, it should save to your designated field -- unless there is not a link between your control and the field.

[Missinglinq]

The rationale for not using spaces in object names is that the Access Gnomes have no way to know that Last Name is a single object. In code you can work around this, by surrounding the name in Square Brackets, as you've done here, but sooner or later you'll forget to do this and spend time trying to figure out why your code is bombing...it's just easier to simply not use spaces. Everyone has their own preferences, here, but an Underscore

Last_Name

or CamelBack formatting

LastName

are the most common.

Your statement

I now have this problem where DLookup only autofills the details for Student ID 1, no matter what Student ID I input into the form

makes me wonder about the Datatype of Student_ID. You syntax is correct if the Datatype is a Number, but if Student_ID is defined as Text, it would have to be

[Last Name] = DLookup("[Last Name]", "Students", "Student_ID = '" & Me.Student_ID & "'")

Linq ;0)>

[June7]

Begs the question - Why are you populating fields with student info anyway? This appears to be duplicating data in multiple tables.