Can I change the tab order if a yes/no box is checked?

[ayupchap]

Hi all, this is my first post here.

I have created a form for a simple database which is being used by another user. Basically I have sorted out the tabbing so moving from one data entry point to another on the form is correct in order but there are many boxes that do not need to be entered If a box is not checked. Is there anyway that the form will miss out certain sections is a tab is not checked? I have very little knowledge of anything outside the basics of access so if there is anyway steps in the most simplest form would be appreciated, saying this I am not sure its even possible.

[ItsMe]

Rather than adjusting the order perhaps something like this in your check box after update event

if me.chkbox.value = -1 then

me.Field1.tabstop = "No"

else

me.Field1.tabstop = "Yes"

end if

[ayupchap]

Oh OK, let me try this. This is new territory for me.

Thanks for your help, I'll let you know how I get on.

[ayupchap]

OK I tried this and it came up with the error Compile error: Method or data member not found. It seemed to focus on the part reading Me.chkbox.value = -1. This is all rather new to me so bit alien. Should I be using the actual name of the chxbox there so say if its called chkbox1 then I would write me.chkbox1.value? Sorry if I sound dumb.

[ItsMe]

Yes, you will need to adjust hte code with the correct names of the controls. If you double click a control while in edit view (clicking the border of the control) the properties pane for that control should appear to the right. You can go to the Other tab and look for the name of that control.

Controls of the Check Box type will have an integer value of -1 when they are checked. Validating this "True" or "Yes" condition should suffice. The other conditions that may exist could be 0 or Null.

Once you validate the condition or value of the checkbox, you can adjust the properties of one or more controls. I used Field1 as a control name example. You will want to insert your control name(s) in its place and repeat the line for each control you want to be affected.

[ayupchap]

OK great thanks so much. I'll try this out.