By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,822 Members | 1,003 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,822 IT Pros & Developers. It's quick & easy.

check box that updates record

P: 1
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
May 22 '07 #1
Share this Question
Share on Google+
1 Reply

MMcCarthy
Expert Mod 10K+
P: 14,534
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

Expand|Select|Wrap|Line Numbers
  1. If Me!frmName = 4 Then ' If others
  2.    Me!Remarks.Visible = True
  3. Else
  4.    Me!Remarks.Visible - False
  5. End If
  6.  
Don't forget to bind the Remarks textbox to the appropriate field.
May 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.