Recent content by divaam

I’m so sorry for duplicate question in difference threads :( I think it was solved but after I try it again there was an error. I try your code but there are new error Run-time error ‘3464’ it said

helo I still have a run time error whe I develop this syntax Me.LblData.Caption = DLookup(Me.cmbIndi, Me.cmbPub, "[Tahun]=" & Me.cmbTahun) the access said run-time error '3075' syntax error (missing operator) in query expression 'Total Hotel' where 'Total Hotel' is the value of cmbIndi can...

helo I still have a run time error whe I develop this syntax Me.LblData.Caption = DLookup(Me.cmbIndi, Me.cmbPub, "[Tahun]=" & Me.cmbTahun) the access said run-time error '3075' syntax error (missing operator) in query expression 'Total Hotel' where 'Total Hotel' is the value of cmbIndi can...

thank you so much for your helping. actually i dont know what is difference function of brackets " "; ' '; & &; [ ]; etc so i'm confused and always have an error syntax:D

just to empty the cell

Hey thank you so much for your help, its work. How if I want to change the button to delete button?

thank you so much, it did work! So happy, thank you once again

I want to display the data to label when I choose 3 combobox cmbIndi is the field that I want to display the data cmbPub is the table cmbTahun is the criteria from field "Tahun" LblData.Caption = DLookup([cmbIndi.value], [cmbPub.value], "[Tahun]=" & [cmbTahun.value]) There are run time error...

still cannot fix this :banghead: would you see the database above? thanks

I will try this, but I have tables to choose too in combobox

here is the database

I want to display the data of the field that I choose based on year for example Year A B C 2008 1 3 4 2009 2 3 2 2010 1 2 3 I have combobox 'comboyear' to choose the year and combobox 'combofield' to choose betwee A,B, or C if I choose year...

Just want to display the data of the field that i choose based on year LblData.Caption = rs(" & Me.cmbIndi.Value & ").Value WHERE (Tahun) = search but syntax WHERE cannot use in here (error) i'm newbie in access, any idea?

still not working

hi, i need your help i have a form 'search' to search single data that I have in some tables. the form contain 3 combobox; 'combotable' to choose table, 'comboyears' to choose field year in table, and 'combofield' to choose the fields in the table. when i click command button i want to display...