Hello all,
Iam newbie here and access.I have problem of creating field which will take input from three other fields.
e.g studNo= (AI default) + RegNo + PGroup,
and it updates automatic.
so how can I write such in VBA?
Thank you for your help
mk
Hello all,
Iam newbie here and access.I have problem of creating field which will take input from three other fields.
e.g studNo= (AI default) + RegNo + PGroup,
and it updates automatic.
so how can I write such in VBA?
Thank you for your help
mk
Base your form on a query and add the following to a new column in the query.
Now open you form in design view, drag "StudNo" from the field list to your form,then save it when you open the form it will display the result you wanted.Code:StudNo: [A1Default] & " " & [RegNo] & " " & [PGroup]
If you don't want the spacing between the fields then do this;
Regards,Code:StudNo: [A1Default] & "" & [RegNo] & "" & [PGroup]
John A