Hi all!

I am stuck with my userform and am in dire need of help!

I am new to VBA and to this forum so please bear with me.

I am working on a userform that allows data entry and to search and update existing data.

I want to be able to enter a certain number (say a Part Number) in one of the fields and click 'Find' and this will search the database for the Part Number and if found, will populate the rest of the fields of the userform with corresponding data. (I have coded this bit and it works).

However, sometimes there maybe more than one record that matches a particular Part Number. In this case, I want to be able to click on a 'Find Next' button to display the next record for this part number. For example if there are 5 records that matches a certain part number, I want clicking on 'find' to show the first record, clicking on 'find next' to show the second record, clicking on 'find next' to show the 3rd record, etc until it shows all 5 records.

If it is easier, I don't mind merging 'Find' and 'Find Next' to one button as long as it does the same job.

This is the code I have so far. I know the 'Find Next' part is wrong because it doesn't work. I am stuck with this and its holding up quite an urgent project, so any help will be so very much appreciated!

Thank you very, very much in advance.

Please Login or Register  to view this content.