Hello,
I have created a database for tracking cell phones and everything was working great until my records got over 110. Now when I bring up record 112 and run the following script I get the information for both record 112 and 12! I think it's the "Like" condition in the last line of code but I have tried to replace it with "=" and that doesn't work. What can I do to fix this? This code is runing as the function of a button when the button is pressed it prints all the information for the selected custodian to the HReceipt form.
Private Sub HReceipt_Click()
'User must select a value from the combo box
If IsNull(CustodianID) = True Then
MsgBox "You must select a keyword."
'Open report called HReceipt where the PartsReplaced field
' contains the value in the hrcustodian combo box
Else
DoCmd.OpenReport "HReceipt", acViewPreview, , "ID Like '*" & ID & "*'"
End If
End Sub
Thank you!
Configuration: Windows XP Internet Explorer 7.0
Athlon 64 (s) 3800 2.4 ghz equivalent intel Call recorder software for sony ericsson w995 Dreamweaver freeware equivalent Dvd ram recorder Excel vba to change conditional formatting per row Function like vlookup that returns multi results Pc game like tekken Query record from excel sheet in excel vba Return new cell address vba Return value based on value vba Running javascript on a webpage form with from vba macro excel Sound recorder free download full version Soundmax equalizer download Value like excel vba Vba copy one row from one table to another word Vba excel copy data record sheet to sheet Vba return value to sheet Vba word copy row