Method 'Item' of object 'Forms' failed

[pledbetter]

Given:


A form frmACMFollowup with a text field Text11, and another unbound form frmCommLog with a text field txtInvoiceNumber,
in the OnClick Event of a Command Button on frmACMFollowup I have:


Dim txtInvNo As String

txtInvNo = Me![Text11]

DoCmd.OpenForm "frmCommLog"

Forms![frmCommLog].[txtInvoiceNumber] = txtInvNo

That last command results in the subject error. The crazy thing is, it was literally working perfectly, then I changed some field names to make more sense, txtInvoiceNumber instead of Text10, for example. And now, this.

[ano]

why you use docmd ? thats a new session not connected to the form as far i remember. try openarg
example show field in new form = forms!...
that suggest your line need into the form not in your routine

[Micron]

Since you have mentioned 2 forms without explaining their relevance I have to assume one is a subform. Perhaps when you renamed something you made existing reference(s) invalid. So if you have compiled your code successfully and still got the error, and decompiled/saved db/recompiled and still got the error then consider posting a zipped copy of your db for analysis.

EDIT - or backtrack to ensure your object references are correct first.

[ano]

btw changing in form need to be done by the menu , more easy to create new form unless its one only and u understand forms.
adding of changing in form by hand is not working

[moke123]

I would add a debug.print for txtInvNo to ensure it's returning what you think it is.
I rarely use a bang, as dot is better tolerated by the compiler and you get intellisense.

then I changed some field names to make more sense, txtInvoiceNumber instead of Text10

Field names or control names?

edit: Also make sure you have option explicit declared and it compiles.

[pledbetter]

I almost always use DoCmd. Never had a problem with it before. Not sure of what you are saying. But I will check OpenArg. Just never used it.

[ano]

i dont know why docmd is often used i just use main with subforms and in vba i arrange the forms and fields hide if needed

[pledbetter]

I almost always use DoCmd. Never had a problem with it before. Not sure of what you are saying. But I will check OpenArg. Just never used it.

[pledbetter]

Since you have mentioned 2 forms without explaining their relevance I have to assume one is a subform. Perhaps when you renamed something you made existing reference(s) invalid. So if you have compiled your code successfully and still got the error, and decompiled/saved db/recompiled and still got the error then consider posting a zipped copy of your db for analysis.

EDIT - or backtrack to ensure your object references are correct first.

Neither form is a subform of the other. As I mentioned above, I am working off the Onclick Event of a Command Button to open an unbound form. I purposely left off redundant code. Here is my algorithm:

1. Copy the content of a Text Box in the current form into a string variable.
2. Open the unbound form
3. Copy the content of the string variable into a Text Box on the newly opened form.

Again, it was working perfectly. Then I made some changes to Text Box names. Then it crashed at "Forms![frmCommLog].[txtInvoiceNumber] = txtInvNo" with that cryptic error.

[moke123]

The DoCmd object exposes a long list of methods to use vba for access actions. OpenArgs is the last argument of the openform and openreport methods and basically allows you to pass an argument to the form or report.

To pass txtInvNo, or simply Text11, you would use:

DoCmd.OpenForm "frmCommLog",,,,,,me.Text11

then in your form open use something like

If not isnull(me.openargs) then
me.txtInvoiceNumber = Openargs
end if

The error message "item" is a property of the forms collection. More than likely you have something mis-spelled or missing.
You didn't answer the question whether you have option explicit declared which may point out your error.

[ano]

changing fields you do by remove and add from form desiign add existing fields or normal text field
dont forget to check the tab order

[moke123]

changing fields you do by remove and add from form desiign add existing fields or normal text fielddont forget to check the tab order

Fields are in tables. Controls are on forms. You can change controls and the fields they are bound to in form design but not the fields themselves.

[pledbetter]

You didn't answer the question whether you have option explicit declared which may point out your error.

It was set to "Compare Database". I changed it to "Option Explicit". No change.

[pledbetter]

The DoCmd object exposes a long list of methods to use vba for access actions. OpenArgs is the last argument of the openform and openreport methods and basically allows you to pass an argument to the form or report.

To pass txtInvNo, or simply Text11, you would use:

DoCmd.OpenForm "frmCommLog",,,,,,me.Text11

then in your form open use something like

If not isnull(me.openargs) then
me.txtInvoiceNumber = Openargs
end if

I am actually passing three values from one form to another. But that's irrelevant. All I want to do is find out why I am suddenly getting this error after simply changing a single control name. I've checked for consistency, spelling, and duplicates, and cannot find anything out of the ordinary.

[moke123]

It was set to "Compare Database". I changed it to "Option Explicit". No change.

should be both

Option Compare Database 
Option Explicit

Does the code compile? Debug>Compile in the vbe

you should declare Option explicit in every module.

also set your options in the vbe to always include variable declaration