Parameter Value Help



Sorry for the repost - but the person helping said I should ask question
again for further help.

I have a database that has been working fine, now it starts asking for
I created a switchboard that opens to screen where user selects name from a
combo box and then a list is populated with a list of his jobs. User then
clicks on job number to go to form to enter time started / completed work on
job. This is the code behind job number click:

Private Sub JobNumber_Click()
On Error GoTo JobNumber_Click_Error

If IsNull(Forms!fWorkLogHiddenOpen!StopTime) Then
DoCmd.OpenForm "fWorkLogReminder"
End If

Exit Sub


If Err.Number = 2501 Then
DoCmd.OpenForm "fGeneralInfo", , , "JobNumber=" & Me!JobNumber
MsgBox "Error " & Err.Number & " - " & Err.Description
End If
GoTo JobNumber_Click_Exit

End Sub

Now, it is prompting for tWorkLog.StartTime and I have no idea why. I know
if anyone can help, more info will probably be needed but I'll wait to find
out exactly what that will be. Any help is greatly appreciated as I've
already spent considerable amount of time searching tables, queries, etc. and
know I'm overlooking something probably very simple.

Thanks in advance,

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads