reports & things

[blade12568]

hi
im still fairly new to this but u will understand why i posted in the general forum as i have more than one problem.

ok im designing a repairshop database

ive got nearly everything working as i want
except some thing proberbly very simple i want to print a report but as an the forms i have with the relevent info from a particular customer/client rather than all records in the database or filtered

ie i suppose its a snapshot.

the second problem is either creating a macro or module but i want to press a button & it copies text from 1 or more fields in a form then pastes them to another field in a different form ? i assume thats possible using VBA but i know nothing about that
but im not bad with macro's

thanx for any help in advance
Brian

 

[cogent1]

Your report will be based on a query. To open the report with a particular Customer's record displayed, make the Customer ID a parameter field in the underlying query and you will be prompted to enter the ID whenever you open the report.

Alternatively, you can call the report from a form which has a combo box listing all your customers. The Customer ID selected in the combo box is then used in the WHERE clause of an SQL statement to select the desired record. A few lines of code can achieve this.

To copy data from one form(Form1) to another(Form2), have both open. In the OnClick event of the button on Form 1, put something like this:

Forms!Form2!MyNewfield=Me!MyField

This can be repeated for multiple fields. (changing the field name of course)

 

[blade12568]

parameter criteria

hi thanx for the help the coping bit was easy one u told me what to put
the first bit however has been a pain ive finally done the criteria in the underlying query but its never worked till tonight guess what has been the problem something so simple as spaces !!
your proberbly thinking yes & well when you new i guess u dont exactly know when there should be a space or shouldnt be

moral of the story is if your a newbie dont over look anything !!