Create Next /Previous command buttons also Modify existing record in a Userform

[rabalam]

I have been diligently working on creating a userform for a week now and I have learned a great deal.. what I mostly learned was that I don’t much.. But none the less I forged ahead. I was able to accomplish a fair amount via the web not so much MS site but other searches that gave me a great base to learn from. Well I have hit my limit of learning and now I need to turn to the professionals for my last ditch effort. Here is a list of things I’d like my form to do:

1. Ability to navigate between next and previous records via buttons – this I have researched and have found some great source but my limited VB scripting has me a bit in the dark as to what variable to change.
2. Ability to word wrap automatically, for some reason I cannot get my text box to wordwrap when it reached the end of the text box itself.
3. Ability to update/modify an existing record
4. Ability to print directly from the form using a print button
5. Ability to search for a record
6. A drop down box gives me the ability to select from 3 different choices (Pass, Fail or Deferred)
That’s it I hope I am very grateful to anyone who can assist me. I am copying my VB code into the body of the post unfortunately I cannot upload my actual file from work.

Please Login or Register  to view this content.

Thank you,

~r

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[rabalam]

I am trying to post like you request but there is no "#" at the top of my post window?