<div>
The form you are trying to display the results in, is it the same form as the Search Form?<br />
<br />
OM Gang
</div>


The form you are trying to display the results in, is it the same form as the Search Form?

OM Gang

<div>
Hi OM Gang<br />
<br />
No it's a different form, same fields but linked to the expressions I am using in the query.<br />
<br />
Regards<br />
<br />
Jeremy
</div>


Hi OM Gang

No it's a different form, same fields but linked to the expressions I am using in the query.

Regards

Jeremy

<div>
Is the Form's RecordSource set to the query? &nbsp;Can you post the query SQL here?<br />
<br />
OM Gang
</div>


Is the Form's RecordSource set to the query?  Can you post the query SQL here?

OM Gang

<div>
Dear Jeff<br />
<br />
Just wanted top say a big thank you, this has been bugging me for days, being a newbie to Db creation and Access I didn't even know about the autoforms!<br />
<br />
Once again thanks.<br />
<br />
Jeremy
</div>


Dear Jeff

Just wanted top say a big thank you, this has been bugging me for days, being a newbie to Db creation and Access I didn't even know about the autoforms!

Once again thanks.

Jeremy

<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
I have created a database for all of our archives and am looking to create a wysiwyg interface for my users. &nbsp;I have created a search form, with fields linked to my data table, and a &quot;search&quot; button to go off and run the query. &nbsp;This works fine and the query results display in the traditional tabular format without any problems.<br />
<br />
What I am now trying to do is take those query results and display them in a form. &nbsp;However, when I run the query to display the results in a form I get the following message in each of the forms fields &quot;#Name?&quot;.<br />
<br />
Can anyone tell me what i've missed because this one is really bugging me :-)<br />
<br />
Thanks<br />
<br />
Jeremy
</div>
</div>


Hi All

I have created a database for all of our archives and am looking to create a wysiwyg interface for my users.  I have created a search form, with fields linked to my data table, and a "search" button to go off and run the query.  This works fine and the query results display in the traditional tabular format without any problems.

What I am now trying to do is take those query results and display them in a form.  However, when I run the query to display the results in a form I get the following message in each of the forms fields "#Name?".

Can anyone tell me what i've missed because this one is really bugging me :-)

Thanks

Jeremy

Display Query Results in a Form - Access 2003

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.