Error - Pls.help

[solar]

Hi,

Can anybody solve this problem...?

i am not able to find out solution for this error type '#Name'

From existing form, when i open another form, i need to store the value of
one text field of the existing form into another form.

I used '=Form![Requisition_Creation]![Requisition_id]' in the another form
of text box control source. But it shows #Name? error.

Even i tried the below code which shows the error

=DLookUp("[Ded_Req_id]","Deduction_Table","[Ded_Req_id]=" &
[Form]!Requisition_Creation![Requisition_id])


Appreciated your solution.

Thanks in advance..

ngr.

 

[Ofer Cohen]

Hi,
The first letter should be "Forms" ad not Form

=Forms![Requisition_Creation]![Requisition_id]

Assuming that the name of the form and the field are correct

 

[solar]

Hi,

Its simply great. working fine...Thanks a lot.

I need two more clarification. Can u please suggest me?

1. Can i hidden the textbox / combobox in Datasheet view..?

2. In 'Order Entry', When we enter 'Order', if the product is not available,
We can create New product by using Double click option and can get in the
existing form. Like that, I need to bring one item to my current form with
new data.

I am able to create. But, not able to get new data. I could get only once I
close & re-open. How to get it in existing form?

Thanks in advance.

ngr.

Hi,
The first letter should be "Forms" ad not Form

=Forms![Requisition_Creation]![Requisition_id]

Assuming that the name of the form and the field are correct

--
Good Luck
BS"D

Hi,

Can anybody solve this problem...?

i am not able to find out solution for this error type '#Name'

From existing form, when i open another form, i need to store the value of
one text field of the existing form into another form.

I used '=Form![Requisition_Creation]![Requisition_id]' in the another form
of text box control source. But it shows #Name? error.

Even i tried the below code which shows the error

=DLookUp("[Ded_Req_id]","Deduction_Table","[Ded_Req_id]=" &
[Form]!Requisition_Creation![Requisition_id])


Appreciated your solution.

Thanks in advance..

ngr.