Unbound Field Problem

[merciless32]

Hello all!
I have an front end password form that I built for a daycare with the help of this forum...thanks to everyone BTW. That piece works perfectly. The parent logs in and the form checks the name and password and then opens a Student Log so that the student can be signed into the facility. This is where it gets ugly.

The Student Log opens and autopopulates the parent name into an unbound field...that happens with no problems, but what I need is for that value to also be dropped into the Student Log table (tblStudent_Log) so that I can run queries off the field. I have searched everywhere for several days and can't find how to insert the data from an unbound field into a table. I think it will either be Insert or Update, but can't figure out how to put it all together.

Thanks in advance, oh, great Access gurus!!!

 

[DJN]

In the After Update event of the unbound text box, add:-

Me.FieldName In tblStudent_Log = UnboundTextBoxName


David

 

[merciless32]

Not working...

Here's my code. Seems like it should work, but it's giving me a syntax error...


Private Sub Parent_AfterUpdate()
Me.Authorized_Parent = Parent
End Sub

I also tried...


Private Sub Parent_AfterUpdate()
Me.Authorized_Parent In tblStudent Log = Parent
End Sub

AND...
Private Sub Parent_AfterUpdate()
Me.Authorized_Parent = Me.Parent
End Sub


I know there is a simple fix for this, but I am stalled...help...

 

[neileg]

I don't understand why you are populating an unbound box. Your code suggests that you have a field on the form called Authorized_Parent and your unbound box is called Parent. Can't you drop your name straight into Authorized_Parent?

Secondly, whenever I have an error in this type of routine, I avoid using the Me shorthand, and specify the object name in full, escpeially if you have subforms in view.

Just some ideas

 

[merciless32]

SUCCESS!!!

THANKS!!!!!!!!!!!!!!!!!!!!!!!!

I dropped took both your suggestions and it worked perfectly. Amazing how something so easy can take so long to figure out! You Rock!