Contrlling two form oopen at the same time

[Lou_Reed]

All the documentation that I have on MS Access 2010 concerns using set focus on a form to move the cursor around from one control to another.



That is fine as far as it goes, but my case is slightly different. I have two forms. You open up the first form and type in say the first name, and last name of a person.

Then upon completing that the form closes, and another form opens; and the second form has what was typed in the first form, plus some additional control such as person's location, phone ext for user input..

Then upon completing the entries in second form, control switches back to the first form to start the whole process again; and the user can then put in someone else on the first form and then the second and so on.

I do not like this opening one form and the next to complete all of the entries. It seems much easier to open the first form and after entry completion the first from stays open and the second form now opens.

The cursor now moves to the top of the second form and entries are made on the second and upon that form's entry completion; control (focus) switches back to the top of the first form; but the second form remains open. The only change is the cursor is now at the top of the first form.

Now both forms remain open and the cursor just moves down one form and then to the top of the next form for data entry.

The only time the forms close is when all entries are complete and they both close.

It seems that if one is putting in a lot personnel and all their relevant entries, this is the better way.

However, my instructions on MS Access 2010 say nothing about switching the cursor (focus) from the bottom of one form to the top of the next form to enter data and then switch back to the first form, etc. This would leave both forms open and the focus just switches from one to the other.

My question is how to do this? I can switch the focus (cursor) around in one form, but to move the cursor to another that is a different story.

How do I do that?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[ranman256]

you DONT need 2 forms open.
use 1 form with all records, put a list box to pick and item then the same form will show the detail by filtering on what was picked

me.filter = "[id]=" & lstBox
me.filterOn = true

or use 2 forms:
use one form, say the list if items to pick from, and this launches the 2nd form for detail, but never close the 1st form. Theres no point.

[Lou_Reed]

I would choose to use two forms instead of combining the two forms into one form. The VBA program was not initially written by me. I believe that there is a reason
for the two forms beyond the current issue that we are discussing. I think other program might be using them also. To combine the two would be a mistake.

So how do I switch cursor (or focus) from the bottom of one form to the top of the other and then do it again upon reaching the bottom of the second form?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed