combo box on form

[ginaburg]

I have 2 tables one with project information and the other with project budget info one to many relationship.

The main form has the project number is a combo box used to find the project. The only other field displayed on the main form is the project name. When I pull up the project, the correct project name comes up with it.
I have a subform with the budget information setup as a continuous form.
I want the user to be able to select the project number from the combo box have the project name appear and then tab to the subform.
How do I get the tab to go from the project number to the subform?

Also, if you hit the tab in the main form, it goes from the project number to project name and back to project number again, it then changes the project name to the next project. How do you stop that from happening?

 

[glalsop]

1) Set the TabStop property of the subform control to 'Yes', then adjust the tab index for the main form.

2) Set the Cycle property of the main form to 'Current record'

-Gary

 

[ginaburg]

Also, when I open the form, the project number field is blank but the project name field is populated. Where is it pulling the project name field from?

Thanks
Gina

 

[glalsop]

Are all of the project numbers blank, or just the first one? Are you sure that all projects have a number in the table?

-Gary

 

[ginaburg]

Thanks for the help on the tab problem, that worked.

There are no blank projects in the table. When you open the form, the project field number is blank but when you click the drop down, all of the projects are listed and it pulls the correct project up. I'm not to concerned that the project number shows blank initially but the project name field is being populated with the same project name everytime. I can't figure out why it would be pulling this particular project. It's in the middle of the table.
If I tab to the budget section and enter data, it updates that project.