Change feild value table

[marzook]

How to change value of records on a designated field,

the table tbleattendance has the fields emplnumber,name,Date,AttendanceType,etc...

the a attendacneType field has the value Present,absent...etc, what i need i want to change the attendaceType value for all employee using form. And form have a commen Combobox for changing the AttendanceType value. once i change the common combobox value its need to be updated on Attendancetype for all records by changing there current values

Form screenshot attached

Please advise............

 

[marzook]

Re: Change field value table

Anyone to help please......

How to change value of records on a designated field,

the table tbleattendance has the fields emplnumber,name,Date,AttendanceType,etc...

the a attendacneType field has the value Present,absent...etc, what i need i want to change the attendaceType value for all employee using form. And form have a commen Combobox for changing the AttendanceType value. once i change the common combobox value its need to be updated on Attendancetype for all records by changing there current values

Form screenshot attached

Please advise............

 

[Rabbie]

Have you considered using an Update query using parameters from the form?

 

[marzook]

No, can you please suggest on how to do

Thanks

 

[Rabbie]

Use the information from your form to build an Update query to make the changes you require then run the query from your code.

See Access help for more info on Update queries.