Visitors records inside a customers database (1 Viewer)

kfenech

New member
Local time
Today, 16:34
Joined
Dec 10, 2016
Messages
1
Hi,
I haven't used Access for quite some time now so my knowledge has deteriorated in time.

I found a couple of templates and managed to change them to a customer database for a friend of mine who basically needs some basic information together with a visitors report. This is where i got stuck. The idea is to have a visitors report within the customer, say customer 1 which already has all details would have a visitors report with all the different reports he had in different dates. The report would only be visible for that client. One would then be able to search client and from there view the visitors report which would have different dates and long text for it.

I did manage to create a customers database which is working pretty well, however i'm having issues creating the visitors reports which would be linked to each client. Would appreciate any help.

Thanks
 

Attachments

  • Karins Database 10.12.16.accdb
    1.2 MB · Views: 48

Ranman256

Well-known member
Local time
Today, 10:34
Joined
Apr 9, 2015
Messages
4,339
Have a form with a list of clients. (Continuous form)
User picks the client,opens the detail form,using:
Docmd.openform "fDetailForm",,,"[id]=" & txtID

Report button is on the detail form.
This opens the report for this ID only using,
Docmd.openreport "myReport",acPreview,"[id]=" & txtID
 

Users who are viewing this thread

Top Bottom