userform search and update

In the attached sample I have a user form with a simple search and update function. I have a similar form that works fine and i copied the code and just renamed what i need and I'm having mixed results.

Search button works the first time, but if I change the job number and click it again it doesn't populate. Here's the code for the search button:

Please Login or Register  to view this content.

The update button doesn't seam to be working at all. Here's the update code:

Please Login or Register  to view this content.

Thanks in advanced for any help with this!

This line of code appears to be your problem:

Please Login or Register  to view this content.

"jobno" is the control name for the Job Number text box on your other form. So in the update form this line cannot find a control/variable called "jobno" and therefore performs the search in column C for a null string.
Change that line to:

Please Login or Register  to view this content.

and all should work as expected.

BSB

One thing I noticed about your workbook is I have to click the button twice to get the form to show.
If you change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

this should then work with a single click.

BSB

Thanks BSB that was it.

I also noticed that this part of the code isn't working now:

Please Login or Register  to view this content.

its not pulling in the dates at all.

also when i click the update it doesn't enter the proper date format. even though i have this assigned to that text box:...this code works in another form...but when i click on that text box it entes a date and comes up with an error.

Please Login or Register  to view this content.

The three lines of code you say aren't pulling in dates are in the other userform right? They appear to be working just fine for me.

For the second question, I would use CDate on the line that stamps the date to the worksheet.

Please Login or Register  to view this content.

This will throw up an error if the field is blank but you can avoid that by using something like:

Please Login or Register  to view this content.

BSB