Dropdown box selection not updating a field on screen.

[rickmason]

Hi All,
I have a database that captures signatures for our nursing area. I do weekly imports of new hires that keep the table updated. Here is my issue..........small but annoying:
When the user selects a name from the dropdown box, the signature field will not update UNLESS the employee has a signature.....Clear as mud? When the DB is opened, the screen defaults to the first record in the table including the signature (first employee has signature on file) If I select a name from the dropdown box who has signed the sigpad yet, the signature from the first employee will still show in the signature field(??) Again, not a major issue I just want this to look profesional. Any ideas? Please let me know if you need more info or if I have totaly confused anyone.

 

[rickmason]

Ooops, typo.
When the DB is opened, the screen defaults to the first record in the table including the signature (first employee has signature on file) If I select a name from the dropdown box who has NOT signed the sigpad yet
^

 

[rickmason]

Can anyone offer any help with this??

 

[jkl0]

What is your code in the After Update property of the combo box.

 

[rickmason]

Hi JK, Here is code..THANKS!!

Private Sub Combo57_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Me![Combo57])
Me.Bookmark = rs.Bookmark
If Signature.Value <> "" Then
SigPlus1.SigString = Signature.Value
End If
End Sub

 

[PHV]

If Signature.Value <> "" Then
SigPlus1.SigString = Signature.Value
[!]Else
SigPlus1.SigString = ""[/!]
End If

Or simply:
SigPlus1.SigString = Signature.Value & ""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886