Populating Access Report from Form [Resolved]

Hi All,

I have an invoice report in an db (access) ofc and its working like a charm. However, I do not know how to populate it using fields on my form. Any help would be appreciated.

The fields will be the typical invoice fields, like phonenumber and cost. I would just like to know how to set my textbox's as the recourdsource to the textbox's in the report.

I await any reply :)

Set up an empty, temp table, that has all the fields your report needs. Based on the user input, run a SELECT query, and dump the resulting recordset into the temp table, and run your report off of that.

Quote:

---

Originally Posted by Hack

Set up an empty, temp table, that has all the fields your report needs. Based on the user input, run a SELECT query, and dump the resulting recordset into the temp table, and run your report off of that.

---

How can you dump a full recordset in an access table?

Quote:

---

Originally Posted by Hack

Set up an empty, temp table, that has all the fields your report needs. Based on the user input, run a SELECT query, and dump the resulting recordset into the temp table, and run your report off of that.

---

How can you dump a full recordset in an access table?

sorry for the double post.. :blush:

Thanks for replying guys,

Tbh I forgot about this post but have since resolved it myself. Thanks again!