query not getting data to form

[rwahdan1978]

Hi



I have a query like this:

SELECT Users.photo, Users.Score
FROM Users
WHERE (((Users.UserName)=[Forms]![Main]![name1].[value]));

if i run the query after opening the main form it will show the correct result. In the form I have the query as the record source and for the photo i put photo and for score i put score but they are empty in the form and nothing is displayed. How to use query as recordset? Can someone show me how or give ne a link to show to use query as recordset?

[June7]

Which form do you want to use this query with?

Certainly form Main must be open for this to work.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Welshgasman]

Think about it.
How can you use form data when the form is not open?
It is what excel would call a circular reference.