Trouble with Navigation Form

[PlamenGo]

I have this problem with Access 2010:
Thre is a Navigation Form, I use to register a sequence od data . On one of the navigation subforms, I select data from a a table, and if the data I need does't exist I need:

1. To pass an info to another form;
2. open the aother form (pop-up over the NavigationForm), and enter the information,
3. close the form and continue with the NavForm ..

In the other forms (regular) I use the code:

Forms![FILE_CUST].[SendWho]=Me.Name
DoCmd.OpenForm "FILE_CUST"

But with the NavForm I get teh Message:

" xxxx cannot find the referenced form 'FILE_CUST'" , and stops at the line:

Forms![FILE_CUST].[SendWho]=Me.Name

Is there a way to resolve this?

 

[John Big Booty]

Welcome to the forum.

I notice you have a field called Name. Name is a reserved word and as such will cause you problems if it is not already doing so in this instance.

 

[PlamenGo]

Sorry for misunderstanding, but Me.Name is an expression taking the value of the Form's Name property .. So I am using the reserved word Name here ...

 

[Bryan]

Is FILE_CUST referring to the Navigation form? I don't have a solution, but I think the problem is that the Navigation form isn't passing values. I tried using one to pass date values for a query but Access acted as if the form was not open. I wound up using the navigation form to open another form to enter the values into.

 

[PlamenGo]

I am moving forward: bypassed (for the moment) the problem with the reference. Made a copy of FILE_CUST form which behaves only as required by the NavForm, and am opening it using a Macro ..., But the Question is still open as I don't like such solutions - they make my project too heavy ...

 

[John Big Booty]

Sorry for misunderstanding, but Me.Name is an expression taking the value of the Form's Name property .. So I am using the reserved word Name here ...

Sorry my bad

 

[Bryan]

I know this isn't the solution you're looking for, but you could close the "intermediate" form with the other form's closing, or maybe close it from a timer.