Ive been having a go at changing the data in the query from the text fields but im having a problem;
Ive created an update query(VX6QUpdate) that writes the data from the query(VX6Query) back to the form (VX6) once it is run.
This works fine and if I edit the data in the query(VX6Query)...
ok got a little further and seem to have it working.
I just recreated the main combo and it seemed to start working.
thanks missinglinq!
now I just have to work out how to create a button that saves the fields in the query back to the original table one I have modified them.
thankyou! I feel like im making some progress now.
Seem to be having a problem still,
Private Sub Cbo_DevName_AfterUpdate()
Me.txt_address = [Cbo_DevName].column3
End Sub
Cbo_DevName is the combo
txt_address is the txt box
I get..
Compile error:
Method or data member not found...
New To access and I'm having a problem with a form.
I have 2 related tables.
I want to produce a form where I can use a combo to select a machine number and view the related fields from both the related tables in text boxs below.
I have done this but cant edit the data;
'Control Cannot be...