Add textbox to userform issue

[ipbr21054]

Hi,
I have a working userform & require a text box just so i can add some brief notes.

I have added the text box to the form ok & written some text into it.
I save it all ok but when i then go back to this customers records on this form i dont see the text that was written ?

My info for all the fields on the userform come from a database,does that mean that the text i wish to see in this text box needs to be entered onto the database also ?

Or if possible i just need to be able to write a line or two & save without the database side of things.

Thanks please advise.

 

[davesexcel]

It could be best to fill textbox1 when you make a selection from the customer combobox

Private Sub ComboBoxCustomersNames_Change()
    If Not EventsEnable Then Exit Sub
    'get record
    r = Me.ComboBoxCustomersNames.ListIndex + startRow - 1
    Navigate Direction:=0
    '----------fill textbox1-------------------
    x = Application.VLookup(Me.ComboBoxCustomersNames, Range("A6:Q" & Cells(Rows.Count, "A").End(xlUp).Row), 17, False)
    TextBox1 = x

End Sub

Possibly you can use your search command to fill the q cell again

    If Me.NewRecord.Caption = "CANCEL" Then
        With Sheets("DATABASE")
            Set C = .Range("A:A").Find(What:=txtCustomer.Value, _
                                       After:=.Range("A5"), _
                                       LookIn:=xlValues, _
                                       LookAt:=xlWhole, _
                                       SearchOrder:=xlByRows, _
                                       SearchDirection:=xlNext, _
                                       MatchCase:=False)
        End With
        If Not C Is Nothing Then
            MsgBox "Customer already Exists, file did not update"
            '-----fill "Q" cell---------
            Cells(C.Row, "Q").Value = TextBox1 '<<<<<<<<<<<<<<
            Exit Sub
        End If
    End If

 

[ipbr21054]

Hi,
Did you try the above as i dont get it to work.

I added the first code & tried then both & tried.

I make a selection from the drop down box,add text & save.
When i check cell Q there is nothing,when i select the same customer from the drop down list the text i wrote is gone.

As you have the file there do you see where the info from my database is being pulled from to be filled into the userform textboxes.
I thought by adding a column Q and putting the text in each correct cell then when i open the userform the textboxes would be filled & even the box we are working on.

 

[davesexcel]

I am don't understand the question, and having trouble deciphering the code.

 

[ipbr21054]

Did you download the file i supplied the link for ?

In the database each rows info is for each specific customer.
When the userform is open how do the textboxes know which textbox needs to be filled with the relevant info from the database.

This is the part i cant remember because once that code is found dont we just the say to the code Also include column Q and then have that info shown in the new text box called Notes.

 

[My Aswer Is This]

I have been monitoring this thread from the beginning and I will say I'm confused:

First you just mentioned entering Text in a Textbox on a Userform and wanting to see same data in same text box next time you opened userform.

But then you said:

When i then scroll through the customers in the userform i should see the text for each customer be shown.​

Scroll thru what ??
You never mentioned a Combobox in your first posting.

I'm confused are we wanting to have just one Textbox and One Combobox on the userform
And when you first open the Userform what text do you expect to see in the Textbox.

 

[ipbr21054]

MAIT

Did you download the file ?

 

[My Aswer Is This]

No:
I never download files.

 

[ipbr21054]

Hmmm
Im trying to advise what is required etc but cant advice if you havent downloaded the file.

How do you then see what im working with ?

 

[ipbr21054]

Hi,
Look in the module called Function Code.
Does that help you ?

 

[ipbr21054]

I think i might of done it davesexcel.

Download this updated file https://drive.google.com/open?id=1ZO8k9vNo_AIW8Av75-3kONL3OjScxpLl