Search results

thanks missinglinq... How, exactly, is the 'custom autonumber' supposed to 'automatically fill' when a new record is started? I thought this code was supposed to check to make sure the box is empty or null and when it is to find the biggest "ControlNumber" and add 1 to it...

thanks Minty.. the highlighting line is the line is the following "Me.txtControlNumber = DMax([ControlNumber], "LOG_tbl") + 1"

by the way the error am encountering is "invalid use of null"

thanks for your help but I still have the same issues here is what I have now Option Compare Database Option Explicit Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec If IsNull(txtControlNumber) Then Me.txtControlNumber = DMax([ControlNumber], "LOG_tbl")...

hello everyone. let me start by saying that your help is much appreciated and by saying that I do not know much about this, please be patient. my issue is the following I have a txtbox which is a custom autonumber which is supposed to automatically fill when the form is loaded with a...

Hello everyone. I have this form called "LOG_frm" and I need it to give me a custom autonumber every time the form is saved and a new record added. I have no problems getting it to do all this, until today. it started checking for the field where the autonumber goes into to see if its null so I...

can you help me out with it? I have tried to create queries before (not for this) and I have no clue on where to begin thanks

hi everyone, I have an issue I would like to get some help with. I currently have a table with the following fields (loginID,Level) there is 10 entries. the "Level" field only has 3 possibilities either (Level 1, Level 2, or Level 3) ideally I would like to have a combobox display...