Access / VB Help

[hegaroo]

i have a access database which in a form calculates the total of some extras in another form, however the vb isnt working the calculation says £15 for each record in the form.

Another 1 is how do i create a report which print previews only one record which can be selected in the form??

email me for the database
heg_uk@hotmail.com
any help appriciated!!

[scrandman]

On your second question - you need to run the report from a query (as opposed to a table).

The query should be a select data type, and the selection parameter should the the object name in your form:

Example:

Form/

Type? [Type]

Query/

Select records from table, where Type = Forms!FormName!Type

Hope this helps - not easy to explain on a keyboard.