check box that updates record

[troiman]

hello. im a new user of ms access and im making a database regarding compliance to documentary requirements.

I have a table (Tbldocuments) whose fields are: credit information sheet, latest income tax return, picture.

I want my form to appear as follows
on file not on file na others

credit information sheet
latest income tax return
picture

under the column "on file", "not on file", "na" , "others", are checkboxes where user will check accordingly.

what i want is that the selected checkbox will update the record and when "others" is selected, a field will appear where user can input his/her remarks. His/her remarks will also updated the record.

please help.

thanks

[MMcCarthy]

hello. im a new user of ms access and im making a database regarding compliance to documentary requirements.

I have a table (Tbldocuments) whose fields are: credit information sheet, latest income tax return, picture.

I want my form to appear as follows
on file not on file na others

credit information sheet
latest income tax return
picture

under the column "on file", "not on file", "na" , "others", are checkboxes where user will check accordingly.

what i want is that the selected checkbox will update the record and when "others" is selected, a field will appear where user can input his/her remarks. His/her remarks will also updated the record.

please help.

thanks

If your form is bound to the appropriate table(s) and your checkboxes are part of an option frame then you will need to code an after update event on the frame using an IF Statement

If Me!frmName = 4 Then ' If others
   Me!Remarks.Visible = True
Else
   Me!Remarks.Visible - False
End If
 

Don't forget to bind the Remarks textbox to the appropriate field.