Recent content by gomsah

If syntax was wrong, wouldnt it give an error or something else? Well, if i change [Brans_adi_L] part of the dlookup function it doesnt update the textbox when combobox is changed. You can see it for yourself in attached file. I just want to insert the query result into table, depending on the...

[Brans_adi_L] is there to update the textbox every time combobox changed. I ve uploaded my db to here. http://www.2shared.com/file/3-vdbEsG/Db1.html You can see that entry form is Ihbargiris On Ihbargiris form, whenever u change the Brans_adi_L combobox, text19 textbox is updated with the...

=DLookUp("Rapor_No_C";"Report_no";[Brans_adi_L]) Report No is the name of the query, and Brans_adi_L is a field in the form. So when user selects a record in the combobox, query calculates the new Rapor_No_C. As i have said. This Dlookup function works when it is in the control source of the...

uhmm, no. How do u get the query result in code? Besides as far as i ve read, it is better to get it done with dlookup() instead of code, right? Btw I can even upload the unworking form if need be.

Thank you for quick answer, but i dont have problems with the usage. I also eliminate null values in query itself using If(Isnull(Field)) My problem is, dlookup() function is working as intended when it is in control source but it doesnt work in default value. I checked syntaxes values...

Hello there I am a newbie in access and i ve been doing some forms for our company's work. I ve come across a problem which is a bit wierd i guess. I dont know if i have to tell every detail but i ll try. I have a combox in my form which gets its data from another tabel, and i got 2 textboxes...