Pull a value from a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that we use to enter calls. I want to be able to have the next
call number appear in a message box when the form is opened. I can get the
message box to appear, but don't know how to retreive the call number from my
call table so it appears in the message box. Any suggestions?
 
I have a form that we use to enter calls. I want to be able to have the next
call number appear in a message box when the form is opened. I can get the
message box to appear, but don't know how to retreive the call number from my
call table so it appears in the message box. Any suggestions?
Click to expand...

Use DMAX and get it that way. Then just include it in your message
string that you use with MsgBox
 
I have a form that we use to enter calls. I want to be able to have the next
call number appear in a message box when the form is opened. I can get the
message box to appear, but don't know how to retreive the call number from my
call table so it appears in the message box. Any suggestions?
Click to expand...

MsgBox "the next call number is " & DMax("[CallNum]","TableName")+1
 
Back
Top