How to display data on my query?

[rexb]

Hi All,

I've 3 tables that I want to query, I want the data to display on a form? How do I do this? My form is a continous form.

Help.

Thank you in advance.

 

[ajetrumpet]

create a query, query the 3 tables, bind the form to it, and open the form.

e.g. - a simple question gets a simple answer

 

[rexb]

I did that, which brings me now to the question, why is there no data displayed when I tried to open the form and even when I tried it on datasheet view, no data displayed I've already have 3 records.

create a query, query the 3 tables, bind the form to it, and open the form.

e.g. - a simple question gets a simple answer

 

[ajetrumpet]

I did that, which brings me now to the question, no data is displayed when I tried to open the form and even when I tried it on datasheet view, no data displayed I've already have 3 records.

THIS IS impossible to tell without seeing the database. Sorry ! The description is too vague, and there could be more than one reason for this.

 

[rexb]

Ok. here is the database. Thanks

 

[rexb]

I hope somebody could help me with this problem