Show past records for same user

[l3111]

Hi
I'm basically teaching myself access whilst developing a database in work, and i'm really stuck!!
Really appreciate any help in advance, been using forums to acheive most of my DB already!!! <3

Bit of background first: My database is for people being entered in a care programme for a period of weeks, however these people can be readmitted to the care programme more than once. What I want to achieve is that when a staff member users the search function (created with help from bloggers!!!) and enters a clients ID number, it brings up a table/list of thier previous entries.

What I then want to be able to do is double click on these entries to open up the case file, so that the information about that admission can be reviewed.

At present, for NEW admissions, there is a tick box for staff to say whether client is Readmission OR New to Programme, can this be used??

I would describe my knowledge as newbie to intermediate, but i have very very very VERY limited knowledge of VB coding.



If any one out there in the cyberspace can help me, i'd be extremely grateful!!!

Taaaaaa
l3111 (Manchester, UK)

[pbaldy]

I wouldn't expect to have to search. I'd probably have a form/subform, where the subform was the previous entries. When the user enters a client ID on the main form, you can either use Master/Child links or requery the subform. Either way, as soon as you enter a client ID the subform would display previous visits. You can use this technique to pull up another form to view a specific previous visit:

BaldyWeb wherecondition

[l3111]

Thats great but where does this code go? (I really am dumb when it comes to VB code )

Do i paste it in to the VB editor or do I record macro using this process?

Thanks for the quick response!!

l3111 (Manchester, UK)

[pbaldy]

What's posted in my link is VBA code, so it would go in the VB editor. You can do the same thing with a macro, but I don't use them so not up on the exact syntax.