Selected form records to report

[Brian62]

I am having problems trying to figure out how to select records from a form to print on a report. Basically I want to click on a refer button to select the record I want to print on a report but allow up to 3 slections on the report. By clicking on the refer button which is on a counter to show how many times the vendor has been refered to a customer and at the same time it should hold that record while clicking next record to select two more records to put on the report. When I hit print record it should print preview first with the three selected records to a single page report.

I hope I explained this well enough. Thanks!

 

[Uncle Gizmo]

Assuming your form is based on a table, then you will probably need to add a new field to that table a "boolean field" (yes no) and flag this field as true meaning this is a record you want to print.

Then create a query which uses the value of this new field as a filter to allow this record to be shown in your report.

Your form will display this new boolean field as a check box, you can now add to the after update event of this check box some code to record how many times this check box is set, this will enable to you to record a number of referrals.

You will probably need a separate field to record this number in your table.

 

[Brian62]

Thanks for the advise. I will try this tonight and get back with you and see if I truly understand to get this working.

 

[Brian62]

I tried what you advised but I think I don't understand what you were saying to get it to work.

I already have a command button (refer) that records the amount of times the vendor has been refered. Once I click the button the count increases by one then I would go to next record the select another record with the refer button . I only do this three times since I only want to refer three vendors on a single report. I should be able to hit print and only print the three selected records on the report. It was once setup to do this but doesn't work any longer. I am coming in after the fact and trying to get it to work again. The table is not setup with a yes/no as you mentioned.

 

[Brian62]

Does anyone else have an idea to fix this problem I am having. Thx

 

[Uncle Gizmo]

>>>The table is not setup with a yes/no as you mentioned<<<

Then what mechanism decides which records should be printed and which records not printed?

 

[Brian62]

That's the problem I have no idea. I was trying to set it up as a Macro but I couldn't get it working. As I hit the refer button the counter next to the button increases by one is what should be used to print the selected reports when I hit print.

I'm sorry I can't give more information because I'm not sure how to explain it.

 

[chewbears]

http://blogs.techrepublic.com.com/howdoi/?p=168

check out this website I think it might have what your looking for. It does what Uncle is talking about and walks you through the how. Why this might not be what you want in your case do the tutorial and you may find that as you go through it you can better ask your question.

 

[Brian62]

It looks like it will work for only one record. Can it be modified to pull three selected records?

 

[Uncle Gizmo]

It looks like it will work for only one record. Can it be modified to pull three selected records?

Well I only had a glance at it but I thought it would pull out any number of records you wanted? Please explain ???

 

[chewbears]

Brain it will do multi records as you complete the tutorial you will see.