Keeping Track of New Records

[markld68]

Hey guys I am new here and I have been working on my database for under a year. I did split it and it's working well so far. One of my co-workers that I did train on how to use the front end of it, we both filled out some of the forms and I explained to him what field to fill and what field is automatically filled in and locked. We have 2 forms that we fill out, the first one feeds the other. On the counseling form we have a button called save to save that record and it goes to a new record. The second form is a log form that we fill out to keep track of how many peolpe we were with. What I am looking for is on the first Counseling form after we press save to save the record then we want the other log form to record a 1 under the field NumberofPeople. I hope this makes sense to you. As we press save on the counseling form a 1 should appear in the NumberofPeople field on the Log form. If and when we press save again it should increment on the Log form the field NumberofPeople to 2 and so forth. They are separate forms and not a sub form. Thanks. I am hoping to use VBA code.

[NeoPa]

Hi Mark.

So many questions and so little clarity of explanation. Yes you can add one to something but before you can add to it you have to know what "It" is - and there's little sign you do - certainly that isn't explained other than it's shown on some other Form. Forms reflect or display data. They don't store it.

Also, the Counselling Form wouldn't typically need a button to save it ('s contents) as that happens automatically with bound Forms in Access. You talk of people who you were with - yet don't explain how that fits into the two Forms you've described. There's very little here you can hang an answer on, but hopefully something in this can help you along a step or two. From there we may manage some progress if you get some clarity as to what you're doing - and share it obviously.

[GazMathias]

Hi markld68,

I understand what you're saying and what you want but I do not understand the reasons behind the requirement or its real world use case.

I have questions about the following:

Why is there a numberOfPeople count and not a collection of records that represent those people?

What does the NumberOfPeople count represent? Patients, Counsellors? The number of times the record was 'viewed'?

If what you want is implemented it will just represent the number of times users clicked the Save button, so what is to stop a user clicking that button over and over for the sake of it? It appears to serve no useful purpose.

I will also advise that hooking additional functionality into a button labelled Save like that is a fundamentally bad design choice, as many users with low computer tolerance/literacy will tend to click such buttons out of habit when they think they are done with the form. If you must, add dedicated buttons with a descriptive labels for such purposes / hook into key events.

Lastly, the title "Keeping Track of New Records" seems to bear no semblance to the content of your post. Reading between the lines it appears that you are asking for someone to explain how to implement a way to do what you describe using VBA. We could do that but we definitely wouldn't in our own solutions so, again, I am struggling with the reasons why?

Gaz