Search results

Hello! I have come up for me very intresting problem. How to assign value to subform group by object. I have main frm and subfrm. when user click a button in mainfrm then it should add value to the subfrm control, but the control is in SQL statement with group by. If somebody didn't understand...

The problem occurd, when my boss found a Marketing manager database, where she held information about projects, the new database holds a lot more information, but these two databases have to be joined. From your statment I got an idea maybe how to put them working :P Thanks

I have form were users can insert confirmation information and table were is held information about projects. I need that when users fill's the Confirmation Form then on closing it would copy some values to the Project Table.

Thanks Thanks with your example and little changes and it helped me too.

Yes, that's correct. But this code doesn't give me the UNimi value to the field Kirj. It gives there value - Select [Kinnitus].KinnituseNR, [Kinnitus].UNimi From [Kinnitus] WHERE [Kinnitus].KinnituseNR = A :(

My code right now is like this: Private Sub KinnituseNR_Change() Dim A As Integer Dim StrSQL As String A = [KinnituseNR] StrSQL = "Select [Kinnitus].KinnituseNR, [Kinnitus].UNimi From [Kinnitus] WHERE [Kinnitus].KinnituseNR = A" Me.Kirj = StrSQL End Sub

Problem is that I want to make bill form, which gets sometimes information from confirmation form, sometimes I have to just type in the information.

When I choose value into a combobox, which is related to table Kin. Then it should change in this form App fields like that Kiri=Nimi Mak=Maks KE=KE Vaar=VaarID Nimi,Maks,KE, VaarID are from table Kin. The problem is that sometimes I don't need automatic information from table Kin and that time...