Sub Form

[Guest]

I have a main form and a subform each has a table. The problem I'm running
into is when I get to the subform, and try to enter info into it nothing
happens. Also if I click in the subform it'll work but it starts at the last
field in the subform. I need it to go to the first field on the subform. How
would I get it to do this? I was told something about the label from the
subform that something has to be entered into this.

Thanks

 

[Guest]

when I get to the subform, and try to enter info into it nothing
happens.

What do you mean? Are you saying that you cannot even enter data in your
form, or that it does not save the data that you enter?

Also if I click in the subform it'll work but it starts at the last

field in the subform. I need it to go to the first field on the subform

Open your form in esign view and go to View, then Tab Order. You can change
the order to whatever you like.

HTH

 

[Pete D.]

Open the sub form in design view and click the menu item View, then TAB
order. Adjust the order of your fields so your cursor goes to the items you
want in the order you want. Now the subform, what it it's source? At table
or a query and what field links it the main form?