Form problem: order forms opened

[rodmc]

Hi Folks

got a small problem which Im sure is pretty simply, here's how it is

I have a form and on the 'On load' event it has an IF statment which checks via DLookup to see if the PK exists in another table, if it does find the PK in the other table it opens another form which I would like to be displyed in front of the form with the 'On load' event.
The If statemnt works, however the form is displayed behind the form with the 'On load' event and not in front.

Is there something I need to add to the form properties or add another line to my If statement?

thanks in advance

 

[missinglinq]

Set the second form's Popup Property to Yes.

But I'm curious about one thing. Does the first form only have one record? Placing this code in the form's OnLoad event means that it will only work for the first record displayed in the original form, not for subsequent records.

Linq ;0)>

 

[rodmc]

Set the second form's Popup Property to Yes.

But I'm curious about one thing. Does the first form only have one record? Placing this code in the form's OnLoad event means that it will only work for the first record displayed in the original form, not for subsequent records.

Linq ;0)>

hi

it displays one record and opens from a search/filter form (continous form), so in effect you could say that the form only displays one record at a time yes. The user does a search see the record he/shes looking for in the filtered subform, hits the open record button and it displays that particular record. That particular record may have an "Alert" record, hence the reason for flashing the pop up.

Rod