Recent content by home70

Gotcha. I can see uses for it both ways. Thanks for your help.

Good to know. It seems to work as it is (although I must say my testing has been less than extensive). What effect would making this change have?

Thanks, vbaInet. I thought I'd share what I've found with future searchers. First, although there is the known bug in Access 2010 when trying to convert a form's macros to code, I found the following work around. On the macro viewing screen, "collapse" the macro, then right click it and...

Thanks, but I am having this problem: http://social.answers.microsoft.com/Forums/en-US/addbuz/thread/edebfb3b-2ab2-4697-872b-d52b9bd0994a Can you help me any further with what code would work?

When I created the list box I used the wizard to create it and selected the option in the wizard saying, "Find a record on my form based on the value I select in my list box". It looks like the wizard uses a macro for the functionality instead of vba code on the list box's events. Can you tell...

Thank you, yes, that's good. I noticed that when I delete a record the form automatically sets itself into "add a new record mode" as if I had pressed the Add button (ie, it 1)shows blank fields and 2) shows are editing record 3 of 3 when there are now only 2 actual records remaining with data...

I'm thinking this wouldn't cause enough performance issues to be a concern for this application and environment. In this situation it is more desirable to have the functionality than to optimize for speed. (If I'm understanding your comment)

OK, what about putting the Save button functionality in the after update of the text box (before the list box requery)?

Thanks vbaInet. The delete works great. The adding only works if I click the add button again after I type something into a text box. (I was trying to get the new record to appear in the list box immediately after typing into a text box - without having to press a button. Is this possible?)

Respectfully, I believe either there has been a miscommunication or that you are mistaken. In post number 5 of this thread I described, step-by-step, my record adding procedure. So when John had suggested, "As part of your procedure to add the new record the last thing you need to do is cause...

I attached it to this post. For a little more information, I've also found that records deleted using the "Delete" button on the form do not leave the list box, and modifications made to records also don't show, until f5 is pressed.

I'm not 100% sure, so I went back and tried to reenact what I did. This is what I believe I did. I created a form with design view and set a query as its record source. Then I used the list box wizard for the list box, selected the option I said above, and on a subsequent screen it asked me...

I'm not sure, but the way I created it was using the wizard and selecting the option on the first screen that says "Find a record on my form based on the value I select in my list box". And there is not any code behind the list box.

I tried it, but it looks like my Access doesn't recognize "refresh" at all.

I add a record by clicking the "Add" button I talked about above, and it clears the text boxes (previously the text boxes would contain info from the record for the item highlighted in the list box mentioned above). Then I type something into one of the text boxes and it creates the record...