[AccessD] Automatic Tracking Number

Hi Mike:

If you are using a SP to save the data, capture the auto-generated id number
and return it, through the SP then you will have to manually place the new
record number on the form.

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: Wednesday, July 27, 2005 7:37 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Automatic Tracking Number

 
Hi Everyone, 

Quick question, I am currently converting all of my tables to SQL and
continuing to use Access as the front end.  Well I have run into one
snag that I can't seem to figure out.  When I enter a new record into
the main table the  tracking number that is automatically being assigned
to the record does not show on the form.  When I had the table on Access
it showed up immediately after I entered the first field of data.  I use
this tracking number to than print a label, but now I have no idea what
number is being assigned.  I look at the SQL table and the record is
there with a tracking number.

Does anyone know how to make the tracking number show on the form?

Thanks for any help that anyone can provide.


Mike Gowey  MCDST, A+, LME, NET+
Team Leader - East Region
Information Systems Unit


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com