QUOTE (missinglinq @ May 29 2012, 09:00 AM)
Is this an app that you created or one that you've inherited?
Where did you check for Default Values? They can be set either at the Table-level or the Form-level.
As Cynthia has said, it's impossible for anyone here to troubleshoot this kind of thing without actually laying eyes on your file. It would also be helpful to know what Form you're talking about and what exact action(s) are needed to recreate what you're seeing.
I inherited the project.
The previous person was let go and I have nobody here to help me out for the most part.
There is a sister form that comes up blank when you open it by itself, no defaults.
When I open the form I started this thread about, it has defaults.
QUOTE (jleach @ May 29 2012, 09:01 AM)
Usually in the Form's Open event we'll put DoCmd.GotoRecord , , acNewRecord
Also check the DefaultValue of each control and table field to see if there's defaults set up there.
On the even tab of the form, there are 3 events:
Private Sub Form_Dirty(Cancel As Integer)
UpdSaved = False
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
Select Case Screen.ActiveControl.Name
stDocName = "frmConsignee_LU"
stDocName = "frmShipper_LU"
Select Case KeyCode
Private Sub Form_Open(Cancel As Integer)
Static MouseHook As Object
Set MouseHook = NewMouseHook(Me)
I dont see a mention like you described.
Also like I said in my second post, the default data it is showing me is the information for the first record in the table the form references.
If I can stop it showing the first record in the table, it would be a big help.