Print Fields from Records in a Form

[solfinker]

Hello!
I have a form I use to add data and I want to print labels - with my label thermal printer - of only one field from each record I have just added to my database, before closing the form, that is, from first record to last record of the recent added records.

I suppose I could fill a table and use it with a report, but I do not know how to do it starting from the form. Can I add records to two tables with the same form?



Thank you for your advise.

[ranman256]

You build a query to grab the records you want to print...save as: qsLabels
Build a report that uses the query qsLabels.

[solfinker]

You build a query to grab the records you want to print...save as: qsLabels
Build a report that uses the query qsLabels.

I build an add query that grabs the records I want to print... but nothing happens, and I do not know why.

1. I fill the form (several recs.)
2. I execute a command that delets the table TableTemp (so far so good)
3. After deleting, the same command runs the append query that appends nothing to TableTemp.
And here I am.

Thank you for your advise!

[solfinker]

Now. I am filling two tables in the same form, one my TableTemp which has been deleted at the opening of the form. Thus I can now print the fields I want from the new records.

Thank you for your hints!