if i wasn't clear i try again:
I have one master unique table wich i need to populate.
I have to populate some fields with the same data ([id] and [ship no.]) that the user selects from combobox.
while thease fields are populated with the constant user selected value, i have further fields...
can't, have less that 10 posts :/
how can i populate the master unique table so that every record created in a subform contains values set in the orignal form?
I.e main form has a field that has value aaa
i want that aaa in every record created in the subform
Hi! I have a form, a subform and a master unique table.
I need the unique table to updated in the following manner:
Form has certain fields that need to be assigned to every record created in the subform[id] and [info1]
Subform has a unique [caseid], and contains further [info2] but needs to be...
Hello! I made this code in excel, and I'd love to get it working in access.
Sub Satunnaisluvut()
Dim OmaAlue As Range
Dim Solu As Range
Set OmaAlue = Range("A1:A5")
For Each Solu In OmaAlue
If Solu.Value = "aa" Then
Solu.Value = "bb"
End If
Next Solu
End Sub
How do i set the wanted field...