Need Help with Update Statement

[rbpd5015]

Hello guys,

I am looking for a bit more help for my Data Entry form for Trivia Questions.

I have now an almost completed form. I can create new records, I can scroll between records.

PROBLEM IS

DAMMM I can not update. the current record.

I want to be able to press the SaveQuestion button and it to save the data as it is in the sheet.

I also have two other small issues

1) When I scroll between records, I want when I reach the top or bottom of the available records for it to circle.
The way it currently is written when I spin button up past row 1 it crashes and gives me an error. I want once Row 2 (NOT 1 because that is an header) for it to go to the last row.

2) I do not want to be able to click more than 1 of the 4 checkboxes at anytime


Below is my code and I have attached my Workbook.

Thanks for any help

Matt

Please Login or Register  to view this content.

[stnkynts]

I should probably chime in on this one too. See the highlighted code for changes. I believe it does what you want:

Please Login or Register  to view this content.

Edit: Just noticed you had a question about the checkboxes. I will get back to you in a bit on that.

Here is the code for the checkboxes. Did I miss anything?

Please Login or Register  to view this content.

[rbpd5015]

Stnkynts,

Man, you have be a lifesaver you are going to save me and my coworkers so much time. I made such a big point on the two minor issue, I didnt explain the biggest issue I think.

If you look at my workbook, I have a three buttons

a new question button which clears all fields and enters the next available record number

a submit question a button which adds all the data to the workbook.

and a save question button which is not setup yet.

This button is so when I am scrolling, if I make a change to a question and click Save Question it saves and updates the question in the workbook.

This is the last pice I believe. Can you please take a look.

Thanks


Matt

[stnkynts]

I believe this will take care of your Save Question Button:

Please Login or Register  to view this content.