make fields active

[spock1971]

hi all

I have a form that has invisible fields. Depending on the navigation to the form, those fields are turned on/off using the visible command.

However, the tab order on the form always takes the user to the first field visible on the form.

How can I tell access to default me a specific field first.

i.e. I have chosen to amend a training file via payroll number. I would like the payroll number data entry box to be the active field when the form opens.

Cheers

 

[Smart]

In the forms on open event

yourpayrollnumberdataentrybox.setfocus

 

[spock1971]

Ah

There be my problem then. If the user opens the same form via another route then I want a different field to be the active one.

Could I do it from the call procedure?

 

[spock1971]

Excellent - it works from the call procedure too.

Thanks