Question on form minimizing

[bwesenberg]

Hello,
I am not really sure if this is a form issue or not.

I am running Access 2002 with a SQL back end for the database in question.

The forms were original run from queries but are now being run from the tables to make them faster.
Since I have done that the users are complaining of an issue when they minimize and then maximize the form.

Here is a little history to explain the process they do.
The open the form and have to hit the New Record button to add a new record. They do that and when they are finished with the record hit the New Record button again. So their form is on a blank record. They will then minimize the form and go into another form. When they maximize the first form to do more data entry the form will go back to the first record in the table instead of being on the New Record they thought it would be on.

Apparently this was working that way when the form was based on a query but since I change it to be based on the Table it started going back to the first record.

Is there anyway to fix this?
If I am not clear about this let me know.

Thanks

[MMcCarthy]

Hello,
I am not really sure if this is a form issue or not.

I am running Access 2002 with a SQL back end for the database in question.

The forms were original run from queries but are now being run from the tables to make them faster.
Since I have done that the users are complaining of an issue when they minimize and then maximize the form.

Here is a little history to explain the process they do.
The open the form and have to hit the New Record button to add a new record. They do that and when they are finished with the record hit the New Record button again. So their form is on a blank record. They will then minimize the form and go into another form. When they maximize the first form to do more data entry the form will go back to the first record in the table instead of being on the New Record they thought it would be on.

Apparently this was working that way when the form was based on a query but since I change it to be based on the Table it started going back to the first record.

Is there anyway to fix this?
If I am not clear about this let me know.

Thanks

Minimizing and maximizing the form doesn't affect the form record view. Something else is going on.

Mary