Search results

I have a combo box with 2 columns "Customer code" and "Customer name", the "Customer code" is the bound column. 1. How can I show the value of the "Customer name" on a separate text box. 2. This combo box is used as a data entry for the new "sales", how can I validate the "Customer name" in a...

Hi Fizzio, As you said, I am making myself complicated and I managed to change my form such that I don't have the Combo Box as a subform. Everything works as it supposed to work!. Thanks for your support, John.

Hi Rich, This will work .... thanks a lot! John.

I have been using this statement: Dim SO As String Dim rs As Recordset SO = "select * from tbl where [SO]= '" + Me.[SO] + "'" Set rs = CurrentDb.OpenRecordset(SO, dbOpenSnapshot) If Not (rs.BOF) Then MsgBox "existing" But this statement only look for the string (in my example "123") and...

Hi Fizzio, Thanks for your quick reply. As I am using the value of the "Source Control" in my Combo Box as the criteria of my query, I want to "clear" the "Combo Box" (this is what I see on my screen) and reset ("null" value) the Source Control in the background of my Combo Box.

How to do I check if an input data (ex. 123) in record already exist or not?. If the input (123) is existing, give a message "existing" and if not ... just record the new number. The check should be "like *123*", as 123 could be in the middle of a long record.

Hi Fizzio, I still have problems ... as my combo box is constructed from a query and I am using the statement: me.recordsetclone.findfirst "[Control Source]='" & me![nameofcombobox] & "'" me.bookmark=me.recordsetclone.bookmark The value changes is not reflected in the "Control Source". What do I...

Hi Fizzio, You are a superstar! ... it works and solved my problem. Thanks a million, John.

Hi Fizzio, I did following: me.[nameof the subform].ctl.value=null but still not doing the reset, though it doesn't give any error messages.

Hi Fizzio, I did what you have suggested, but is still not working, the combo box is a subform in a form. Could thid be the reason why it doesn't work?.

Hi Fizio, Thanks for your reply. The solution you gave to me was more or less the same solution I have behind my reset button_on_click(), but as my solution, your suggested solution is also still showing the old value and not showing a "null" value after the button has been clicked.

I have combo boxes used in a form to make selections criteria of a query and would like to reset all the combo boxes in one click (empty the contents of the combo boxes) using a "Reset" button. Any idea's how to do this?