• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Input box string

I want to use an input box so that the next number can be entered. I want the message on the input box to say the last number used was (blah,blah), I know that  DLast ("aceuip", "EquipMaster") will get me the last used number but cant figure out how to put the whole message together
0
Spikemom
Asked:
Spikemom
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Something like this:

InputBox "Last number used: " & DMax("[aceuip]", "EquipMaster") & " . Please enter next number"

mx
0
 
Dale FyeCommented:

Why not just generate the next number?

NZ(DMAX("aceuip", "EquipMaster"), 0) + 1

0
 
SpikemomAuthor Commented:
Excellent
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now