Solved: Sheet Code is not working correctly

[Hoopsah]

Hi

I have created an input sheet that reads the reference number from a database.

If the reference number exists it will populate the appropriate cells. If it doesn't exist it will pop an error message up.

All Cool.

However, I want to have the reference cell blank when entering this screen and after the submit button has been clicked, but whenever I blank the cell I get my error message saying record doesn't exist.

Anyone know how I can fix this?

Copy of workbook attached.

P.S. Does anyone know how to make a cell always be in uppercase?

Thanks for any help

Hoopsah

[Bob Phillips]

Try this

[Hoopsah]

Hi Bob,

thanks for replying.

The sheet now accepts a bland cell (And thanks for the uppercase too) however, the submit button macro isn't working now.

When you call an existing record and amend some of the details, click submit and the error message "Not a valid reference" pops up, then the "Record amended" messagebox pops up and the screen is cleared - but when you view the database no changes have occurred.

[Bob Phillips]

This should do it

[Hoopsah]

Fantastic

Once again works perfectly.

Thanks Bob

Gerry

[Hoopsah]

Hi Bob,

wonder if you can help me again.

I downloaded your attachment that works perfectly, but when I copied it into my workbook I keep getting an error message that 'Range of object'_Worksheet' failed.

I can't see anything different from your original attachment
</IMG>
I have attached the full workbook

[GTO]

Greetings Gerry,

Hope you don't mind, I took a peek

In the Amend Data worksheet I checked the insert names dialog. "RefNo" shows as "=#REF!$F$6" in the refers to box.

Does that help?

Mark

[Hoopsah]

Hi Mark

thank you - that is exactly what was wrong. I think I had been staring at it too long to see anything. I have amended the reference and it now works perfectly.

Thanks for your help

Cheers

Gerry

[GTO]

...staring at it too long to see anything...

I've certainly been at that "location" way too many times!


Very glad to help

Mark