|  | Form | | |
| | | Pass-the-reality |  |
|  Posted: Wed Sep 03, 2008 10:39 pm Post subject: Form |  |
I have a form called frmSpecialistView. On this form I added a button
through the wizard to open another form called frmCallLog. When I select the
button, I want frmCallLog to open (which is does), However I the form to
force the auto number. In the VB code it says
stDocName ="frmCallLog"
DoCmd.OpenForm stDocName, , , stLink Criteria
I added
Me.AgentName.SetFocus
Me.Dirty =True
AgentName is a field on the form frmCallLog. I thought maybe be forcing it,
it would change my ID number from Auto Number to an actually number. HELP!!! |
| |
| | | Linq Adams via AccessMons | |
| | Posted: Wed Sep 03, 2008 11:10 pm Post subject: Re: Form | |
***Why*** do you need an AutoNumber assigned ***before*** you've actually
created a new record? In point of fact, you probably shouldn't even be
displaying the AutoNumber on your form. As John Vinson has said here many
times, AutoNumbers are not fit for human consumption, but perhaps you have a
compelling reason to display them!
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
LINK |
| |
|
|
