Recent content by rayape

Simply brilliant! Thank you sir.

@June7 and/or others. Please see the attached db. When I click the 'New Submittal' button, the form creates a new record and requeries the list box. At this point, if I use the 'Previous Record' button to see what my last entry was, an error message pops. It says 'No Current Record'. What is...

@June7 Please see the attached db. The button with caption New Command Button is where I inserted part of the code. Thank you for helping.

Did you modify code to use your form names? I doubt you need the If Then block - I probably should not have included it. I did modify the code to match my form names. It didn't work. I actually have the procedure in a general module because it is called by multiple forms that are interacting...

Thank you, @CJ_London I created a module and pasted the code. Created a button on frm_Submittal and typed Viewdata "next". When I click the button, it shows runtime error 424. Object required.

Thank you sir. Will fix them all. Please let me know where to use the code.

@June7 Thanks for the help. I will use more definitive names. Where do I paste this code? Other than using definitive names, what are other problems with my database/vba? Thank you all.

Hello All, please refer to the attached database. I have the following questions. I would appreciate your guidance. Thank you. 1. Are the tables/fields/relationships/queries set up correctly? 2. In frm_Products, the pull down menu to filter the list works only sometimes. I don't know why...

@cheekybuddha - worked like a charm! Thanks. @theDBguy - thanks again for helping. Unrelated question: how do you folks and others in this forum know so much about Access? Is it just building a lot of applications? Is it studying books? What study material would you recommend for a beginner?

Hello, I have the following code to filter a listbox based on a combo box selection. I need a separate button that can clear the filter and display all records. I don't know how to do. Need help from learned members here. Thanks. This filters the listbox based on the combo box selection ...

Thank you, cronk, pbaldy and arnelgp. Appreciate your help.

Ok. How would I do that? Sorry, these questions are perhaps too fundamental. Thank you.

I used the idea from here. https://www.access-programmers.co.uk/forums/threads/get-a-combo-box-to-filter-data-in-a-listbox.191901/

I am a beginner’s beginner. Sorry to bother, but if you don’t mind, would you please tell/show me how to fix the problem to make it work? Thank you.

All - Please see the attached file. When I make a selection using the Combo box, the Listbox goes blank. I need the Listbox to filter data based on selection made using the Combobox. What am I doing wrong? Need your help, please. Thank you.