displaying records to users

  • Thread starter Thread starter Kyle Friesen via AccessMonster.com
  • Start date Start date
K

Kyle Friesen via AccessMonster.com

Hello,
I have a form that users will enter data in via combo boxes, list boxes,
etc. A save record command button executes a macro that maps and IDs each
record. A view records command button opens a select query which the users
may view the mapped entries. The mapping results in a concatenated "project
tracking number".

My question is: how can I display this project tracking number in a MsgBox
after the save record command is selected? I currently have a "Record Saved
Successfully" MsgBox.

For example:
MsgBox "Record Saved, Your Tracking Number is 123456"

Thanks.
 
Kyle,

try this -

If tracking number is numeric field, then use

MsgBox "Record Saved, Your Tracking Number is " + CSTR(tracking_number)

If its string then you can use it directly as

MsgBox "Record Saved, Your Tracking Number is " + tracking_number

where tracking_number is the form field or variable.

Hope this helps
-Me
 
Back
Top