Weird symptom when opening a form I created

[docroc]

Hi -

I created an app for keeping track of our IT inventory. There are several forms:

Asset List shows all records in the Assets table. For the form's OnCurrent event, I tell it to open the form AssetDetail, which shows details of the particular asset. Works OK. Here's the code for openingAssetDetail:


Private Sub Form_Current()
DoCmd.OpenForm "AssetDetail", acNormal, , "AssetTag = Forms![Asset List]![AssetTag]"
End Sub



I have a form Seat List, which shows all seats (people's workstations basically). Using the same kind of logic as Asset List, it opens Seat Detail when the OnCurrent event is triggered.for Seat List. Here's that code:

Option Compare Database

Private Sub Form_Current()
DoCmd.OpenForm "Seat Detail", acNormal, , "SeatID=Forms![Seat List]![SeatID]"

End Sub


But, with all forms closed, if I open Seat List, I get a message asking for a value for the asset tag....


....and, if I say OK, then the AssetDetail form is open as well as the two seat-related forms.


If I delete the code in Asset List for opening AssetDetail, then the problem with Seat List goes away.

My intuition is that this has something to do with the modules, but I don't know what.

I appreciate any guidance.

Thanks,
David

[Minty]

I've never seen the current event used to open another form.
Normally you would use a click or double click event or a command button.

The current event fires every time you move from one record to another. I can't imagine wanting to open a form every time you moved records.
The normal way to do that would be to have that data displayed in a sub form linked to the main form data, that is displayed all the time, so you aren't constantly opening and closing the same form.

Any chance you could upload a stripped own version of your DB with enough ambiguous data to let us see what is happening.

[Micron]

I agree with the above. One thing that could cause this is that you have one or more "things" (e.g. a calculated control or sql statement) on one of the forms (possibly seat list) that refers to the asset list form. Seems to me that you'd be better off using a main form/subform design.

[docroc]

Thank you both for your advice. I moved both openform procedures to the ondoubleclick events in their respective forms, and the weirdness vanished.

Best,
Dave