Recent content by lbnear

Thanks Allan, When I did my search in the forum I somehow missed that thread. It sounds like I'll be able to implement the logic. Lisa

Bob, Not a problem... you've already given me a tremendous amount of help. I'm self taught and am thankful to have found this forum. I will keep poking around the site and hopefully will be able to make this current database more efficient and effective. Thanks again, Lisa BTW - I didn't...

Bob, The reason I have a form (and corresponding table) for each person (maybe it was a lack of Access understanding on my part) is that I need them to each enter their hours without being able to: a) open someone else's form (I still have security work on the database to do) b) I don't want...

Ray and Bob, THANK YOU!!!! The final solution of putting it in the "on enter" works like a charm. I tested multiple project adds and on multiple user forms and it works. Lisa

Ray, If you open "Alison Solano - Input Form" you'll see the "Add Course/Program" button next to the "Course/Program/Project" combo box. When I add a new program and go back to Alison's form, it's there; however, if I do it a second time the new program is not in the combo box. Thanks again...

Sorry about not being clear, I was testing the requery on the "on click" of the combo box on the main form. rainman, I tried the me.requery in the combo box and still am only getting the first update from the "add project" form. The subsequent updates are not being reflected in the combo box...

Thanks Bob and rainmain, After testing rainman's suggestion, and not being able to get it to work, I went to "on click" on the main form (surprisingly to me, I did this on my own - so Bob, thanks for the validation.). However, I can't get my syntax to work there! Since now I'm not pointing to...

When my users are entering data for a project, if they do not see the project in the combo box list on the main form, they can click on a command button that will take them to another form where they can add the project. On the second form, there is a "save" command button and and "return to...

The majority of my users have a roller ball mouse. When they use it on a two page form (thinking they are going to the bottom of the form), they unintentionally go to the next record. What code can I use to disable the roller ball on the form (or enable the roller ball to scroll through the...

RuralGuy, Thank you very much! You've solved my problem - your last solution works like a charm.

Gemma's idea works; however, the list (table) I'm using has over 100 entries. My users SHOULD know what project they're working on, but they usually don't and wouldn't think to enter the next key! Thanks for your help guys!

That's almost it! Okay, I entered your code (thank you again!), but I cannot scrole down using the arrow. My example is: I type "b" and get black, I use the down arrow, the list with blue comes up, but the down arrow ceases to work (I can't get to any of the other choices, without then using...

Oh so close!!! Okay, so I tested your suggestion (thank you!); however, I don't want to always display the list... only if I don't like the choice I get when I enter the first letter. In other words, when I hit "b", if I don't want black (the first b word in my list) but blue (the second b...

Can the combo box on a form be formatted (maybe by macro?) so that the user who is completing the input can use their down arrow when they are in the combo box to reveal all of the choices in the list? E.G. the user tabs to the new field, types "b" for black (and the word black appears), but...