Recent content by Pirie

Hi, I'm trying to add an ID for a new record and want the field to automatically display the correct ID number in sequence which is one more than the last record in the table. I'm struggling with this one

Private Sub Form_Load() If Me.NewRecord Then Me!RecordIDTextbox = Nz(DMax("RecordID", "TableName"),0) + 1 End If End Sub Thanks for that code but I get an error message when entering this code. My table is called property and the field is property ID. I take it that RecordIDTextbox should...

Where would I enter that code?

One further question! One another form I have an ID number field which is not autonumber as the field is part of a relationship. The form is to be used to enter a new record and I would like the number of the next record to be displayed in the textbox when the form is opened, how do I do this...

Thanks missinglinq, Got it working now, Thanks a lot guys!

Hi, I have a form which is to be used for editing/deleting data from a table and was wondering if it was possible to select which record from a combo box which would populate the textboxes on the form allowing me to edit the data? If so, how do I do it? Thanks