When run the paramaeter query it shows #name

[Frank Situmorang]

Hello,

When I run find form ( a parameter qeuery), it opens the form for the
record, but for some fields it shows #Name.

Can anyone help me what goes wrong?, I have check the control, nothing wrong
with the name of the control source

With many thanks in advance

 

[John W. Vinson]

Hello,

When I run find form ( a parameter qeuery), it opens the form for the
record, but for some fields it shows #Name.

Can anyone help me what goes wrong?, I have check the control, nothing wrong
with the name of the control source

Check the fieldnames in the Form's Recordsource as well; they must exactly
match the names in the form controls' Control Source property.

If any of the names contain blanks - or any character other than letters,
numbers, and underscores - then the fieldnames and control names must be
consistently enclosed in [square brackets].

John W. Vinson [MVP]

 

[Frank Situmorang]

John, thank you for your prompt response. When I view it in the form view,
all fileds are ok, only if when I perform searching the all the linked table
fields shows #Name

I f you could explain again
--
H. Frank Situmorang

Hello,

When I run find form ( a parameter qeuery), it opens the form for the
record, but for some fields it shows #Name.

Can anyone help me what goes wrong?, I have check the control, nothing wrong
with the name of the control source

Check the fieldnames in the Form's Recordsource as well; they must exactly
match the names in the form controls' Control Source property.

If any of the names contain blanks - or any character other than letters,
numbers, and underscores - then the fieldnames and control names must be
consistently enclosed in [square brackets].

John W. Vinson [MVP]

 

[John W. Vinson]

John, thank you for your prompt response. When I view it in the form view,
all fileds are ok, only if when I perform searching the all the linked table
fields shows #Name

You will have to explain how you "perform searching" and what the "linked
table" is, and how you are displaying it.

John W. Vinson [MVP]

 

[John W. Vinson]

Hello,

When I run find form ( a parameter qeuery), it opens the form for the
record, but for some fields it shows #Name.

Please post the SQL view of the parameter query, and the SQL view of the
Form's recordsource. It would also help if you would post the Control Source
properties of some of the controls which show #Name.

John W. Vinson [MVP]