Form Is Not Recognized by Access

[Larry B]

I have been developing in VB 6.0 for a couple years. After
changing jobs, I have been asked to modify a VB application
written using Access 2002. I have added a new Form and a
new Module. When I run the program and try to look at
object properties, I get the following error message:

"<DCIM-PC can't find the form 'Update Report' referred to in a macro
expression or Visual Basic code.>"

when I break on

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

Update Report is the Form I created. The line above is
contained in Module cmdUpdateReport.

The existing code contains a Form named DCI Simulator. In
module cmdDCISimulator there is a line of code with

Forms![DCI Simulator]!TransmitWindow.SetFocus

that works perfectly.

I am currently without an explanation. There are no
declarations of Forms or Modules anywhere, and everything
appears in the main project window. I'm probably missing
some fundamental concept of Access programming, but I can't
figure out what it might be.

 

[Chris O'C via AccessMonster.com]

Is the form Update Report already open when that line of code runs?

Chris
Microsoft MVP

I have been developing in VB 6.0 for a couple years. After
changing jobs, I have been asked to modify a VB application
written using Access 2002. I have added a new Form and a
new Module. When I run the program and try to look at
object properties, I get the following error message:

"<DCIM-PC can't find the form 'Update Report' referred to in a macro
expression or Visual Basic code.>"

when I break on

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

Update Report is the Form I created. The line above is
contained in Module cmdUpdateReport.

The existing code contains a Form named DCI Simulator. In
module cmdDCISimulator there is a line of code with

Forms![DCI Simulator]!TransmitWindow.SetFocus

that works perfectly.

I am currently without an explanation. There are no
declarations of Forms or Modules anywhere, and everything
appears in the main project window. I'm probably missing
some fundamental concept of Access programming, but I can't
figure out what it might be.

 

[Stuart McCall]

I have been developing in VB 6.0 for a couple years. After
changing jobs, I have been asked to modify a VB application
written using Access 2002. I have added a new Form and a
new Module. When I run the program and try to look at
object properties, I get the following error message:

"<DCIM-PC can't find the form 'Update Report' referred to in a macro
expression or Visual Basic code.>"

when I break on

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

Update Report is the Form I created. The line above is
contained in Module cmdUpdateReport.

The existing code contains a Form named DCI Simulator. In
module cmdDCISimulator there is a line of code with

Forms![DCI Simulator]!TransmitWindow.SetFocus

that works perfectly.

I am currently without an explanation. There are no
declarations of Forms or Modules anywhere, and everything
appears in the main project window. I'm probably missing
some fundamental concept of Access programming, but I can't
figure out what it might be.

One important difference between VB and Access VBA is that in Access, when
you refer to textboxes and comboboxes you need to specify the Value property
instead of the Text prop. In Access, the Text prop is only valid while the
control has focus. So try changing your line:

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

to:

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Value

HTH

 

[Larry B]

Negative; Form has been closed and Focus set to previous Form.

Is the form Update Report already open when that line of code runs?

Chris
Microsoft MVP

I have been developing in VB 6.0 for a couple years. After
changing jobs, I have been asked to modify a VB application
written using Access 2002. I have added a new Form and a
new Module. When I run the program and try to look at
object properties, I get the following error message:

"<DCIM-PC can't find the form 'Update Report' referred to in a macro
expression or Visual Basic code.>"

when I break on

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

Update Report is the Form I created. The line above is
contained in Module cmdUpdateReport.

The existing code contains a Form named DCI Simulator. In
module cmdDCISimulator there is a line of code with

Forms![DCI Simulator]!TransmitWindow.SetFocus

that works perfectly.

I am currently without an explanation. There are no
declarations of Forms or Modules anywhere, and everything
appears in the main project window. I'm probably missing
some fundamental concept of Access programming, but I can't
figure out what it might be.

 

[Larry B]

Thanks. I still get "<DCIM-PC can't find the form 'Update Report' referred
to in a macro expression or Visual Basic code.>" when I set a breakpoint.
It's as if the Form doesn't exist in the mind of Access (such as it is).

I have been developing in VB 6.0 for a couple years. After
changing jobs, I have been asked to modify a VB application
written using Access 2002. I have added a new Form and a
new Module. When I run the program and try to look at
object properties, I get the following error message:

"<DCIM-PC can't find the form 'Update Report' referred to in a macro
expression or Visual Basic code.>"

when I break on

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

Update Report is the Form I created. The line above is
contained in Module cmdUpdateReport.

The existing code contains a Form named DCI Simulator. In
module cmdDCISimulator there is a line of code with

Forms![DCI Simulator]!TransmitWindow.SetFocus

that works perfectly.

I am currently without an explanation. There are no
declarations of Forms or Modules anywhere, and everything
appears in the main project window. I'm probably missing
some fundamental concept of Access programming, but I can't
figure out what it might be.

One important difference between VB and Access VBA is that in Access, when
you refer to textboxes and comboboxes you need to specify the Value property
instead of the Text prop. In Access, the Text prop is only valid while the
control has focus. So try changing your line:

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

to:

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Value

HTH

 

[Chris O'C via AccessMonster.com]

Open the Update Report form before running that line of code and Access will
be able to find the form. The form isn't part of the Forms collection unless
it's open.

The default property for a combo box is value, so you can use the name of the
combo box in code and its value will be used in the expression. If you use
the text property of a combo box or text box and the control doesn't have the
focus, you'll get the error message "You can't reference a property or method
for a control unless the control has the focus."

Chris
Microsoft MVP

 

[Larry B]

Okay; that got it. It was closing the Form prematurely. I'm on to a new set
of problems now. Thanks very much; I can now let the swelling go down...

Larry

Thanks. I still get "<DCIM-PC can't find the form 'Update Report' referred
to in a macro expression or Visual Basic code.>" when I set a breakpoint.
It's as if the Form doesn't exist in the mind of Access (such as it is).

I have been developing in VB 6.0 for a couple years. After
changing jobs, I have been asked to modify a VB application
written using Access 2002. I have added a new Form and a
new Module. When I run the program and try to look at
object properties, I get the following error message:

"<DCIM-PC can't find the form 'Update Report' referred to in a macro
expression or Visual Basic code.>"

when I break on

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

Update Report is the Form I created. The line above is
contained in Module cmdUpdateReport.

The existing code contains a Form named DCI Simulator. In
module cmdDCISimulator there is a line of code with

Forms![DCI Simulator]!TransmitWindow.SetFocus

that works perfectly.

I am currently without an explanation. There are no
declarations of Forms or Modules anywhere, and everything
appears in the main project window. I'm probably missing
some fundamental concept of Access programming, but I can't
figure out what it might be.

One important difference between VB and Access VBA is that in Access, when
you refer to textboxes and comboboxes you need to specify the Value property
instead of the Text prop. In Access, the Text prop is only valid while the
control has focus. So try changing your line:

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Text

to:

Select Case Forms![Update Report]!cboUpdateReportTriggerStatus.Value

HTH