CMD opens RPT in Design Mode, not FRM called

I

Ivan Grozney

I have an application where our Fire Department inputs their daily Company
Journal. Every 4 or 5 months or so for a couple of users (and not the same
users...) get a very strange error. I don't know what is going on and I
cannot replicate the error.

The users click on the button for the day/station and instead of the form
where they enter their data, it opens up a report (the one they would run at
the end of their shift) in Design Mode. Weird... Even weirder to me is that
after two or three days (maybe enough reboots???) it seems to work again.

It is supposed to open up the form f rm_JournalMain
but it opens the report rpt_JournalMainCMB
in Design Mode!

Here is the code. Does anyone see what the heck could cause such a thing to
happen?

Access 2003 with MS SQL Server 2000 back end.

tia

*********************** Code Start *********************
Private Sub Fire1_Click()

Dim Ndays As Byte
Dim varD As Variant
Dim varS As Variant

Me.StationNo = "1"

varD = DLookup("[JournalID]", "tbl_JournalMain", "[Jdate] = #" _
& Forms!frm_sb!SelectDate & "# AND [stationid] = " & Forms!frm_sb!StationNo)

HowLong varD, varS, Ndays
End Sub

~~~~~~~~~~~~~~~~~~~~ Called Public Sub ~~~~~~~~~~~~~~~~~

Public Sub HowLong(vd As Variant, vS As Variant, Nd As Byte)

Dim stDocName As String, stLinkCriteria As String
Dim varD As Variant, varS As Variant
Dim Ndays As Byte, zstationid As Byte
Dim zsdate As Date
Dim whoDat As Variant, daysr As Variant

' Set the lock flag on Main Switchboard to null
Forms!frm_sb!FormLock = Null

' Pass in the variables from the calling procedure and from the form
varD = vd
varS = vS
Ndays = Nd
whoDat = Environ("username")
zsdate = [Forms]![frm_sb]![SelectDate]
zstationid = [Forms]![frm_sb]![StationNo]
' Pass in the ID of the currently logged in use and see how many days they
can edit
daysr = DLookup("[daystoedit]", "qry_VerifyUserName", "[UserID] = " &
Chr(34) & whoDat & Chr(34))

' If set the days allowed to edit to the days from the DLookup
If daysr > 0 Then
Ndays = daysr
Else
' If the user is not in the list, then give the RnF (Rank and File) number
of days to edit.
Ndays = DLookup("[daystoedit]", "qry_verifyusername", "[FireTypeGroup] =
" & Chr(34) & "RnF" & Chr(34))
End If

' Set the form and the link information to open the form with
stDocName = "frm_JournalMain"
stLinkCriteria = "JDate = #" & zsdate & "# AND stationid = " & zstationid

' Pass in the editable days and set the lock flag if necessary
If [Forms]![frm_sb]![SelectDate] <= Date - Ndays Then
' If the Station and date variables are set and the No. Days is too out
of date,
' open the form read only. However, if there no journal for that date,
pop up a
' message to inform them of that fact.
If Not IsNull(varD) And Not IsNull(varS) Then
Forms!frm_sb!FormLock = "F"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly
Else
MsgBox "Sorry, There is no Journal match for Station " & _
[Forms]![frm_sb]![StationNo] & " on " _
& [Forms]![frm_sb]![SelectDate] & "!", vbOKOnly, _
"Journal Doesn't Exist!"
End If
' They are not allowed to enter in journal information into the future.
ElseIf [Forms]![frm_sb]![SelectDate] > Date Then
MsgBox "You cannot create a journal entry in the future, sorry...", _
vbOKOnly, "No Fortune Telling Please!"
Forms!frm_sb!SelectDate = Date
Else
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
End If

End Sub

************************ Code End *********************
 
I

Ivan Grozney

I opened the system and then rather than using the command button on the
form, I opened the form from the FORMS object window. If I opened it, it
would open the report. If I hit design, then it popped up the correct form
in design mode. Then when I switched back to form view, it got an error
(send to Microsoft so they don't do anything and restart).

This makes me think that something in application data or something deep
down in the system is hosed up.


Has anyone else seen this problem? Any ideas on how to fix it?

tia

Vanya

Ivan Grozney said:
I have an application where our Fire Department inputs their daily Company
Journal. Every 4 or 5 months or so for a couple of users (and not the same
users...) get a very strange error. I don't know what is going on and I
cannot replicate the error.

The users click on the button for the day/station and instead of the form
where they enter their data, it opens up a report (the one they would run at
the end of their shift) in Design Mode. Weird... Even weirder to me is that
after two or three days (maybe enough reboots???) it seems to work again.

It is supposed to open up the form f rm_JournalMain
but it opens the report rpt_JournalMainCMB
in Design Mode!

Here is the code. Does anyone see what the heck could cause such a thing to
happen?

Access 2003 with MS SQL Server 2000 back end.

tia

*********************** Code Start *********************
Private Sub Fire1_Click()

Dim Ndays As Byte
Dim varD As Variant
Dim varS As Variant

Me.StationNo = "1"

varD = DLookup("[JournalID]", "tbl_JournalMain", "[Jdate] = #" _
& Forms!frm_sb!SelectDate & "# AND [stationid] = " & Forms!frm_sb!StationNo)

HowLong varD, varS, Ndays
End Sub

~~~~~~~~~~~~~~~~~~~~ Called Public Sub ~~~~~~~~~~~~~~~~~

Public Sub HowLong(vd As Variant, vS As Variant, Nd As Byte)

Dim stDocName As String, stLinkCriteria As String
Dim varD As Variant, varS As Variant
Dim Ndays As Byte, zstationid As Byte
Dim zsdate As Date
Dim whoDat As Variant, daysr As Variant

' Set the lock flag on Main Switchboard to null
Forms!frm_sb!FormLock = Null

' Pass in the variables from the calling procedure and from the form
varD = vd
varS = vS
Ndays = Nd
whoDat = Environ("username")
zsdate = [Forms]![frm_sb]![SelectDate]
zstationid = [Forms]![frm_sb]![StationNo]
' Pass in the ID of the currently logged in use and see how many days they
can edit
daysr = DLookup("[daystoedit]", "qry_VerifyUserName", "[UserID] = " &
Chr(34) & whoDat & Chr(34))

' If set the days allowed to edit to the days from the DLookup
If daysr > 0 Then
Ndays = daysr
Else
' If the user is not in the list, then give the RnF (Rank and File) number
of days to edit.
Ndays = DLookup("[daystoedit]", "qry_verifyusername", "[FireTypeGroup] =
" & Chr(34) & "RnF" & Chr(34))
End If

' Set the form and the link information to open the form with
stDocName = "frm_JournalMain"
stLinkCriteria = "JDate = #" & zsdate & "# AND stationid = " & zstationid

' Pass in the editable days and set the lock flag if necessary
If [Forms]![frm_sb]![SelectDate] <= Date - Ndays Then
' If the Station and date variables are set and the No. Days is too out
of date,
' open the form read only. However, if there no journal for that date,
pop up a
' message to inform them of that fact.
If Not IsNull(varD) And Not IsNull(varS) Then
Forms!frm_sb!FormLock = "F"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly
Else
MsgBox "Sorry, There is no Journal match for Station " & _
[Forms]![frm_sb]![StationNo] & " on " _
& [Forms]![frm_sb]![SelectDate] & "!", vbOKOnly, _
"Journal Doesn't Exist!"
End If
' They are not allowed to enter in journal information into the future.
ElseIf [Forms]![frm_sb]![SelectDate] > Date Then
MsgBox "You cannot create a journal entry in the future, sorry...", _
vbOKOnly, "No Fortune Telling Please!"
Forms!frm_sb!SelectDate = Date
Else
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
End If

End Sub

************************ Code End *********************
Click to expand...
 
K

Ken Snell \(MVP\)

My thought is that you have code attached to the form's Open or Load or
Current event, and that code is opening the report. Look at the code module
for the form and see what code is there.
--

Ken Snell
<MS ACCESS MVP>




Ivan Grozney said:
I opened the system and then rather than using the command button on the
form, I opened the form from the FORMS object window. If I opened it, it
would open the report. If I hit design, then it popped up the correct
form
in design mode. Then when I switched back to form view, it got an error
(send to Microsoft so they don't do anything and restart).

This makes me think that something in application data or something deep
down in the system is hosed up.


Has anyone else seen this problem? Any ideas on how to fix it?

tia

Vanya

Ivan Grozney said:
I have an application where our Fire Department inputs their daily
Company
Journal. Every 4 or 5 months or so for a couple of users (and not the
same
users...) get a very strange error. I don't know what is going on and I
cannot replicate the error.

The users click on the button for the day/station and instead of the form
where they enter their data, it opens up a report (the one they would run
at
the end of their shift) in Design Mode. Weird... Even weirder to me is
that
after two or three days (maybe enough reboots???) it seems to work again.

It is supposed to open up the form f rm_JournalMain
but it opens the report rpt_JournalMainCMB
in Design Mode!

Here is the code. Does anyone see what the heck could cause such a thing
to
happen?

Access 2003 with MS SQL Server 2000 back end.

tia

*********************** Code Start *********************
Private Sub Fire1_Click()

Dim Ndays As Byte
Dim varD As Variant
Dim varS As Variant

Me.StationNo = "1"

varD = DLookup("[JournalID]", "tbl_JournalMain", "[Jdate] = #" _
& Forms!frm_sb!SelectDate & "# AND [stationid] = " &
Forms!frm_sb!StationNo)

HowLong varD, varS, Ndays
End Sub

~~~~~~~~~~~~~~~~~~~~ Called Public Sub ~~~~~~~~~~~~~~~~~

Public Sub HowLong(vd As Variant, vS As Variant, Nd As Byte)

Dim stDocName As String, stLinkCriteria As String
Dim varD As Variant, varS As Variant
Dim Ndays As Byte, zstationid As Byte
Dim zsdate As Date
Dim whoDat As Variant, daysr As Variant

' Set the lock flag on Main Switchboard to null
Forms!frm_sb!FormLock = Null

' Pass in the variables from the calling procedure and from the form
varD = vd
varS = vS
Ndays = Nd
whoDat = Environ("username")
zsdate = [Forms]![frm_sb]![SelectDate]
zstationid = [Forms]![frm_sb]![StationNo]
' Pass in the ID of the currently logged in use and see how many days
they
can edit
daysr = DLookup("[daystoedit]", "qry_VerifyUserName", "[UserID] = " &
Chr(34) & whoDat & Chr(34))

' If set the days allowed to edit to the days from the DLookup
If daysr > 0 Then
Ndays = daysr
Else
' If the user is not in the list, then give the RnF (Rank and File)
number
of days to edit.
Ndays = DLookup("[daystoedit]", "qry_verifyusername", "[FireTypeGroup]
=
" & Chr(34) & "RnF" & Chr(34))
End If

' Set the form and the link information to open the form with
stDocName = "frm_JournalMain"
stLinkCriteria = "JDate = #" & zsdate & "# AND stationid = " &
zstationid

' Pass in the editable days and set the lock flag if necessary
If [Forms]![frm_sb]![SelectDate] <= Date - Ndays Then
' If the Station and date variables are set and the No. Days is too
out
of date,
' open the form read only. However, if there no journal for that
date,
pop up a
' message to inform them of that fact.
If Not IsNull(varD) And Not IsNull(varS) Then
Forms!frm_sb!FormLock = "F"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly
Else
MsgBox "Sorry, There is no Journal match for Station " & _
[Forms]![frm_sb]![StationNo] & " on " _
& [Forms]![frm_sb]![SelectDate] & "!", vbOKOnly, _
"Journal Doesn't Exist!"
End If
' They are not allowed to enter in journal information into the future.
ElseIf [Forms]![frm_sb]![SelectDate] > Date Then
MsgBox "You cannot create a journal entry in the future, sorry...",
_
vbOKOnly, "No Fortune Telling Please!"
Forms!frm_sb!SelectDate = Date
Else
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
End If

End Sub

************************ Code End *********************
Click to expand...
Click to expand...
 
I

Ivan Grozney

Ken,

I put this in the wrong post… Thanks for answering and for the ideas.

Sure enough in the On Current event I was trying to reset the printers
to the default printer. I guess something there is not working correctly. I
hunt it down.

There doesn’t seem to be anything in the On Load that causes this
behavior but I have included it just in case you see something that I have
missed (again).

Any ideas on how to reset the reports to the default printer?


***************** On Current Code Start *************************
Dim rpt As AccessObject
Me.FormLock = Forms!frm_sb!FormLock

For Each rpt In CurrentProject.AllReports
DoCmd.OpenReport rpt.Name, acViewDesign ', , , acHidden
If Not Reports(rpt.Name).UseDefaultPrinter Then
Reports(rpt.Name).UseDefaultPrinter = True
DoCmd.Save acReport, rpt.Name
End If
DoCmd.Close
Next rpt
If Me.FormLock = "F" Then
Me.frm_CallTypeSUB.Enabled = False
Else
Me.frm_CallTypeSUB.Enabled = True
End If
***************** On Current Code End *************************


***************** On Load Code Start *************************
If IsNull(Me.Command1) Or IsNull(Me.SiftID) Or IsNull(Me.EnteredBy) Then
Me.frm_CallTypeSUB.Visible = False
Me.frm_EquipSUB.Visible = False
Me.frm_CallTypeSUB.Visible = False
Me.ApparatusIssues.Visible = False
Me.Staffing.Visible = False
Me.DailyOperations.Visible = False
Me.Training.Visible = False
Me.TrainingWater.Visible = False
Me.TWGallons.Visible = False
Me.txtFitness.Visible = False
Me.txtStationIssues.Visible = False
DoCmd.Close acForm, "frm_OpenSplash"
End If
' Turn the MouseWheel Off
Dim blRet As Boolean
blRet = MouseWheelOFF

***************** On Load Code End *************************

Thanks,
Vanya


Ken Snell (MVP) said:
My thought is that you have code attached to the form's Open or Load or
Current event, and that code is opening the report. Look at the code module
for the form and see what code is there.
--

Ken Snell
<MS ACCESS MVP>




Ivan Grozney said:
I opened the system and then rather than using the command button on the
form, I opened the form from the FORMS object window. If I opened it, it
would open the report. If I hit design, then it popped up the correct
form
in design mode. Then when I switched back to form view, it got an error
(send to Microsoft so they don't do anything and restart).

This makes me think that something in application data or something deep
down in the system is hosed up.


Has anyone else seen this problem? Any ideas on how to fix it?

tia

Vanya

Ivan Grozney said:
I have an application where our Fire Department inputs their daily
Company
Journal. Every 4 or 5 months or so for a couple of users (and not the
same
users...) get a very strange error. I don't know what is going on and I
cannot replicate the error.

The users click on the button for the day/station and instead of the form
where they enter their data, it opens up a report (the one they would run
at
the end of their shift) in Design Mode. Weird... Even weirder to me is
that
after two or three days (maybe enough reboots???) it seems to work again.

It is supposed to open up the form f rm_JournalMain
but it opens the report rpt_JournalMainCMB
in Design Mode!

Here is the code. Does anyone see what the heck could cause such a thing
to
happen?

Access 2003 with MS SQL Server 2000 back end.

tia

*********************** Code Start *********************
Private Sub Fire1_Click()

Dim Ndays As Byte
Dim varD As Variant
Dim varS As Variant

Me.StationNo = "1"

varD = DLookup("[JournalID]", "tbl_JournalMain", "[Jdate] = #" _
& Forms!frm_sb!SelectDate & "# AND [stationid] = " &
Forms!frm_sb!StationNo)

HowLong varD, varS, Ndays
End Sub

~~~~~~~~~~~~~~~~~~~~ Called Public Sub ~~~~~~~~~~~~~~~~~

Public Sub HowLong(vd As Variant, vS As Variant, Nd As Byte)

Dim stDocName As String, stLinkCriteria As String
Dim varD As Variant, varS As Variant
Dim Ndays As Byte, zstationid As Byte
Dim zsdate As Date
Dim whoDat As Variant, daysr As Variant

' Set the lock flag on Main Switchboard to null
Forms!frm_sb!FormLock = Null

' Pass in the variables from the calling procedure and from the form
varD = vd
varS = vS
Ndays = Nd
whoDat = Environ("username")
zsdate = [Forms]![frm_sb]![SelectDate]
zstationid = [Forms]![frm_sb]![StationNo]
' Pass in the ID of the currently logged in use and see how many days
they
can edit
daysr = DLookup("[daystoedit]", "qry_VerifyUserName", "[UserID] = " &
Chr(34) & whoDat & Chr(34))

' If set the days allowed to edit to the days from the DLookup
If daysr > 0 Then
Ndays = daysr
Else
' If the user is not in the list, then give the RnF (Rank and File)
number
of days to edit.
Ndays = DLookup("[daystoedit]", "qry_verifyusername", "[FireTypeGroup]
=
" & Chr(34) & "RnF" & Chr(34))
End If

' Set the form and the link information to open the form with
stDocName = "frm_JournalMain"
stLinkCriteria = "JDate = #" & zsdate & "# AND stationid = " &
zstationid

' Pass in the editable days and set the lock flag if necessary
If [Forms]![frm_sb]![SelectDate] <= Date - Ndays Then
' If the Station and date variables are set and the No. Days is too
out
of date,
' open the form read only. However, if there no journal for that
date,
pop up a
' message to inform them of that fact.
If Not IsNull(varD) And Not IsNull(varS) Then
Forms!frm_sb!FormLock = "F"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly
Else
MsgBox "Sorry, There is no Journal match for Station " & _
[Forms]![frm_sb]![StationNo] & " on " _
& [Forms]![frm_sb]![SelectDate] & "!", vbOKOnly, _
"Journal Doesn't Exist!"
End If
' They are not allowed to enter in journal information into the future.
ElseIf [Forms]![frm_sb]![SelectDate] > Date Then
MsgBox "You cannot create a journal entry in the future, sorry...",
_
vbOKOnly, "No Fortune Telling Please!"
Forms!frm_sb!SelectDate = Date
Else
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
End If

End Sub

************************ Code End *********************
Click to expand...
Click to expand...
Click to expand...
 
K

Ken Snell \(MVP\)

To change a printer to the default printer, you use this code step:

' change back to the default printer
Set Application.Printer = Nothing

--

Ken Snell
<MS ACCESS MVP>


Ivan Grozney said:
Ken,

I put this in the wrong post. Thanks for answering and for the ideas.

Sure enough in the On Current event I was trying to reset the printers
to the default printer. I guess something there is not working correctly.
I
hunt it down.

There doesn't seem to be anything in the On Load that causes this
behavior but I have included it just in case you see something that I have
missed (again).

Any ideas on how to reset the reports to the default printer?


***************** On Current Code Start *************************
Dim rpt As AccessObject
Me.FormLock = Forms!frm_sb!FormLock

For Each rpt In CurrentProject.AllReports
DoCmd.OpenReport rpt.Name, acViewDesign ', , , acHidden
If Not Reports(rpt.Name).UseDefaultPrinter Then
Reports(rpt.Name).UseDefaultPrinter = True
DoCmd.Save acReport, rpt.Name
End If
DoCmd.Close
Next rpt
If Me.FormLock = "F" Then
Me.frm_CallTypeSUB.Enabled = False
Else
Me.frm_CallTypeSUB.Enabled = True
End If
***************** On Current Code End *************************


***************** On Load Code Start *************************
If IsNull(Me.Command1) Or IsNull(Me.SiftID) Or IsNull(Me.EnteredBy) Then
Me.frm_CallTypeSUB.Visible = False
Me.frm_EquipSUB.Visible = False
Me.frm_CallTypeSUB.Visible = False
Me.ApparatusIssues.Visible = False
Me.Staffing.Visible = False
Me.DailyOperations.Visible = False
Me.Training.Visible = False
Me.TrainingWater.Visible = False
Me.TWGallons.Visible = False
Me.txtFitness.Visible = False
Me.txtStationIssues.Visible = False
DoCmd.Close acForm, "frm_OpenSplash"
End If
' Turn the MouseWheel Off
Dim blRet As Boolean
blRet = MouseWheelOFF

***************** On Load Code End *************************

Thanks,
Vanya


Ken Snell (MVP) said:
My thought is that you have code attached to the form's Open or Load or
Current event, and that code is opening the report. Look at the code
module
for the form and see what code is there.
--

Ken Snell
<MS ACCESS MVP>




Ivan Grozney said:
I opened the system and then rather than using the command button on the
form, I opened the form from the FORMS object window. If I opened it,
it
would open the report. If I hit design, then it popped up the correct
form
in design mode. Then when I switched back to form view, it got an
error
(send to Microsoft so they don't do anything and restart).

This makes me think that something in application data or something
deep
down in the system is hosed up.


Has anyone else seen this problem? Any ideas on how to fix it?

tia

Vanya

:

I have an application where our Fire Department inputs their daily
Company
Journal. Every 4 or 5 months or so for a couple of users (and not the
same
users...) get a very strange error. I don't know what is going on and
I
cannot replicate the error.

The users click on the button for the day/station and instead of the
form
where they enter their data, it opens up a report (the one they would
run
at
the end of their shift) in Design Mode. Weird... Even weirder to me
is
that
after two or three days (maybe enough reboots???) it seems to work
again.

It is supposed to open up the form f rm_JournalMain
but it opens the report rpt_JournalMainCMB
in Design Mode!

Here is the code. Does anyone see what the heck could cause such a
thing
to
happen?

Access 2003 with MS SQL Server 2000 back end.

tia

*********************** Code Start *********************
Private Sub Fire1_Click()

Dim Ndays As Byte
Dim varD As Variant
Dim varS As Variant

Me.StationNo = "1"

varD = DLookup("[JournalID]", "tbl_JournalMain", "[Jdate] = #" _
& Forms!frm_sb!SelectDate & "# AND [stationid] = " &
Forms!frm_sb!StationNo)

HowLong varD, varS, Ndays
End Sub

~~~~~~~~~~~~~~~~~~~~ Called Public Sub ~~~~~~~~~~~~~~~~~

Public Sub HowLong(vd As Variant, vS As Variant, Nd As Byte)

Dim stDocName As String, stLinkCriteria As String
Dim varD As Variant, varS As Variant
Dim Ndays As Byte, zstationid As Byte
Dim zsdate As Date
Dim whoDat As Variant, daysr As Variant

' Set the lock flag on Main Switchboard to null
Forms!frm_sb!FormLock = Null

' Pass in the variables from the calling procedure and from the form
varD = vd
varS = vS
Ndays = Nd
whoDat = Environ("username")
zsdate = [Forms]![frm_sb]![SelectDate]
zstationid = [Forms]![frm_sb]![StationNo]
' Pass in the ID of the currently logged in use and see how many days
they
can edit
daysr = DLookup("[daystoedit]", "qry_VerifyUserName", "[UserID] = " &
Chr(34) & whoDat & Chr(34))

' If set the days allowed to edit to the days from the DLookup
If daysr > 0 Then
Ndays = daysr
Else
' If the user is not in the list, then give the RnF (Rank and File)
number
of days to edit.
Ndays = DLookup("[daystoedit]", "qry_verifyusername",
"[FireTypeGroup]
=
" & Chr(34) & "RnF" & Chr(34))
End If

' Set the form and the link information to open the form with
stDocName = "frm_JournalMain"
stLinkCriteria = "JDate = #" & zsdate & "# AND stationid = " &
zstationid

' Pass in the editable days and set the lock flag if necessary
If [Forms]![frm_sb]![SelectDate] <= Date - Ndays Then
' If the Station and date variables are set and the No. Days is
too
out
of date,
' open the form read only. However, if there no journal for that
date,
pop up a
' message to inform them of that fact.
If Not IsNull(varD) And Not IsNull(varS) Then
Forms!frm_sb!FormLock = "F"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormReadOnly
Else
MsgBox "Sorry, There is no Journal match for Station " & _
[Forms]![frm_sb]![StationNo] & " on " _
& [Forms]![frm_sb]![SelectDate] & "!", vbOKOnly, _
"Journal Doesn't Exist!"
End If
' They are not allowed to enter in journal information into the
future.
ElseIf [Forms]![frm_sb]![SelectDate] > Date Then
MsgBox "You cannot create a journal entry in the future,
sorry...",
_
vbOKOnly, "No Fortune Telling Please!"
Forms!frm_sb!SelectDate = Date
Else
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
End If

End Sub

************************ Code End *********************
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cmd Button Does not work on first click 2
Code Opens form when there is no Data ? See Code Below. Thanks, Dave 1
MsgBox if no matching record is found ? Thanks in Advance, Dave 1
Link Criteria and Open Form Code Help, Thanks in Advance 6

Top