report of current record

[xenia]

I have got a tricky problem, for which I can find no answer - but then I am a bit of a novice here.

I have created a (probably too-) complicated relational database but what I really need is to be able to make abutton on the page of my address book form, so that when I hit it it creates a report of an address label for that current record on the screen only.

I hope this makes sense. If this is possible, I then need to extrapolate this technique to print a report of a subform (of samples sent) of a current client record.

All help gratefully received

Xenia

 

[The Stoat]

Hi,

Here is an example.

The address table TBL_ADDRESSES has a Compound Primary Key and an Autonumber ID set to No duplicates.
The address form uses a query [QRY_ADDRESSES] with all the fields from the TBL_ADDRESSES.
The forms View report button opens a report that uses a copy of QRY_ADDRESSES called QRY_ADDRESS_FOR_REPORT. This query uses the Autonumber ID from the forms underlying query to select only the record that is displayed on the form.

The report will then display only the current record being viewed on the form.

I've saved the DB as Acess97 so you should be able to view it in all current versions of Access.

HTH

TS

 

[xenia]

thanks

Many thanks Stoat. i have opened it and had a quick gander. It seems to make sense to me, but am currently embroiled in other ghastly problems with a website. when exhausted I will return to Access and give your example a go.

VERY many thanks for your time and energy. will report back later!

cheers

X

 

[xenia]

Thanks Stoat!

Absolute genius. Problem solved with a little rearranging to suit my d/b.

Most grateful.

Xenia

 

[richl]

sorry to open an old topic but im trying to do the same as xenia - print a report of the current record.

Can anyone explain how I use a query to select only the record that is displayed on the form?

Thanks