Search results

Re: Maybe in sql server??? Dear jdraw, you are mistaken. It works in Access 2010! First: test. Then: post reply.

You may also succeed with this: Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.Open "SELECT @@IDENTITY As ID", CurrentProject.AccessConnection Dim lngMyLastAutoNumber As Long lngMyLastAutoNumber = rst!ID rst.Close This method returns the last generated autonumber in your...

Tried to reproduce this behaviour. Without success. What do you mean by saying "editing the table"? Do you want to open it in 'design view' mode? ----------------------- StarGrabber

Re: slightly 'simpler' way Well done Isskint. I can't find the 'downside' you mentioned. Using both your code and mine there are no preset values after opening the form because there was no form update event. But I found other downsides: With your code it's not possible to use string values...

The setting 'No' for the data entry line is set by default so I guess that your form has this setting already.With it, the desired feature does not work, at least on my computer it didn't. I hope you have some knowledge in VBA. If so, try the following (adapted to your application of course)...