Adding a new form

[Guest]

I have a form with survey questions. The last item is a yes/no check box.
How do I tell access to go to new form after that box is checked or tabbed
over. Also I have a combo box that has multiple answers. When I tab into it
how do I tell it to use the arrow kesy to choose the correct answer.

 

[Guest]

These can both be done with a macro.

I have a form with survey questions. The last item is a yes/no check box.
How do I tell access to go to new form after that box is checked or tabbed
over.

Create a macro with an Action of OpenForm in which you specify the form
name. Save the macro with a meaningful name. In your first form, select the
checkbox and go to the Events tab of the properties and select the macro you
just created in the On Got Focus or After Update event, whichever one you
want. When the event fires, the macro will run.

Also I have a combo box that has multiple answers. When I tab into it

how do I tell it to use the arrow kesy to choose the correct answer.

Another macro. You probably don't want to simulate arrow keys. Rather, you
should have the macro set the value of the combobox. In a macro, use the
SetValue action. Set the Item property to the combobox on your form with this
syntax:
Forms!MyFormName!MyComboName

In the Expression property, put the value you want to set the combobox to.
Back on your form, choose the name of this macro for the combobox's
OnGotFocus event.

Barry

In the