Can you upload screenshots? I'm confused what you're trying to do.

If you want to increment the field, you just need to do FieldName = FieldName + 1 but depending on if they're bound or unbound and what else you have going on, there may be a lot more you need to do.

Hi Adam, I sent a picture with details to your email of what we are asking for and hoping to do in the 2 forms. Thanks.

Hi Mark. Generally, we ask that you post your screen shots here and don't just send files by email unsolicited. Please see Rule 5.

OK thanks, however A few months ago i was able to post screen shots. Now I cannot get them to load. As I try to load screenshots it says it must be about 500KB per picture. I tried to get mine to get under 500K but no success so now I cannot post until I do. trying different software to no success. Sorry forgot about the rules. I do text the information here in detail until i am able to get my pictures there.

Mark, what are you using for taking screen shots? I can make a pretty large screen shot at 1280x720 and it's still under 400k. And that's a HUGE image.

Finally i just used prtSc on the keyboard instead of my iphone. On each form we have a save button so it not only saves the record but it also refreshed to a new one. 2 questions, the form on the left has totalminutes per call so however long the call was we would like it to auto fill, as we press save on the counseling form, in on the right counselor Log form where the call length is with a 1 and increment up each time a call is in between that time period. Second is as we press save on the left form not only the totalminutes but also on the right form is shows number of calls, part of which is covered, each call that we get and press save that would be 1 call. As we get another call and press save then that number of calls increments up each time. Any suggestions? I am looking into using IF then else for the call length with gotocontrol gotorecord. Or is there a different way.Thanks.

That's a much better image. I can actually read it now. :)

I cover something similar to this in my Time & Billing database.

I think I did watch that video, time to rewatch. I am also going back to see the ones that you did about changing query to i think vba, so we don't have lot's of queries just very few. Thanks.

Hi Richard, I watched the video but nothing. Any other suggestions. I already am showing some people how to work the DB and some made the suggestion that after the totalminutes gets calculated then it auto inserts into the other form. Any other suggestions, I'm still looking myself.

Eureka!  I found what you need ( I think - if I'm understanding your desires ).

Tell me if I'm understanding correctly.  
So Scott calls in and wishes to speak to a counselor, in this case Mark. When I call, you open the form and the Call start time in inserted into the StartTime. When the session ends your Save fills in the EndTime and TotalMinutes is calculated.  That part you have down OK - Correct?

When you save the record you are creating (PrayerCounselingLogF) you want to find Mark's record in the summary log (CounselorLogF)
AND if the length of the call was 23 minutes say, take what ever is in Call Length 11-30 Minutes and add 1 call to that counter.

Good so far?

So now what you need is a small little lookup table - We'll call it TipT (TimeInPrayerT)  You want the ID of course but also the minimum time values to match.
Take a look at the VLOOKUP in Access video to see how you can use your times, instead of grades, to figure out what field to update.

Once you figure out what time slot it falls in it is just a matter of using your update statement(s) to increment the correct field.
This isn't for the beginner for sure.  You're going to have to put in some learning time in the previously suggested videos to accomplish this.  DLookup, Update Queries, Value From a Form will all help.  Do a search and give it a shot.

Meanwhile - update the record manually until you get it working.

BTW - Work on developing with a COPY of your db, when you have tested it out, then update the "live" copy with the new feature. Backup your work.  Both the development db and the live db.

PS - If you have not already done so it sounds like it is time for you to Split Your Database.
That will also make it easier to develop and update your programs (forms, reports, code) while keeping your actual data separate.

Hi Scott, yes that's what we are looking for it to do. I already got several questions about what does what. Also they were asking different questions about things in it I already corrected. I already split it only on a trial bases. I'll look up that vlookup in access also. Looking at several different options too. I'm also looking into into after pressing save then it puts a 1 in the calls box. Thanks Scott

Hey Scott one more question. I bought the calendar form seminar, and it's working out great. One of our directors, Frank was asking about auto inserting the data. I saw the video on adding records automatically and I made a continuous form from the calendarT, now it's working better but Richard uses msgbox. Any idea's on how to use drop down menu instead?

Mark, the calendar form from the Calendar Seminar is just a way of displaying the data from the underlying tables.
If you followed Richards instructions that data will be "automatically be inserted" in the display form.  If you have modified the calendar to fit your needs - That is on you.

I suspect I'll be talking to the proverbial brick wall but a great deal of the frustrations and questions come from a lack of knowledge.  Somewhere along the line you have to say - Here it is guys.  Work with the db as it is.  Write down any of your problems and desires and I'll look into adding to the v2 of the program.

You really just need to go through the courses one by one.  If your "Director" want things done, and they are not willing to belly up to the bar, to get you that education, Oh well.  Guess they get what they get  OR  You have to decide that this is important enough to you to personally spend the time and $$ to get that education and provide what they are looking for.

And remember... usually you don't need to store data in a table that can easily be calculated from other data. For example, an order total. You don't need to store that number in the order table because you can easily calculate it by summing up the cost of the items on the order. Same here. Why store the same number twice?

Hey Scott Axton, after reading your responce to my question about the call length I did go to those video's and watched them. I had to rewatch several times the dlookup and match it with mine. I did make the tables put the time and tried it and it did work. Now to figure out the way to just put 1 instead of the actual time so it can increment it.