Searching Database Using Textbox on Userform

[CianScarborough]

Hello VBA experts

I have been looking over the many posts in relation to this type of function but I cannot get any of the examples I've found to work for me.

Problem:

I have created a form that will add new records to a database. On the database there is a predetermined ticket number. The "Create" form looks for the first blank row and adds the information on the form the database.

What I am trying to make happen is when a "Ticket Number" is entered in the approriate field on the "edit" form, the "Date Raised" and "Raised By" fields populate based on the information stored on the row for the ticket number enter.

I have attached a simplified version of my workbook. If you have any questions please let me know.

Many Thanks

Cian

[Kaper]

Try in code of your userform something like:

Please Login or Register  to view this content.

[CianScarborough]

That worked perfectly, thank you Kaper.

Have you any idea on how I would create a save button that updates the database if new data is entered in either field?

[Kaper]

Exactly the same way shall work equally well

Just instead of

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

and of course change the procedure name to reflect Button name

After writing both values you may want to notify user that values were updated and ask "what next" :-P