control positioning of form when "not on list" envoked

[bbilotta]

I have a form that contains a combo box. if the data entered in the combo box is not in the list a "not in list" event is triggered.



this event opens a form in Add mode.

The problem is that form is opening on a completely different screen (i have 3 for instance).

Can i constrain the form to open within the boundaries of the main form?

[ranman256]

make a sub form. it will stay in the main form.
keep it invisible until needed.

[bbilotta]

Thank you, but I don't always need the form. i only need the form if/when the user needs to enter a new value in the original drop down list.
i don't want to create a situation where the user automatically creates new data simply because they misspelled the name.

The user needs to select a dog club from the drop down. the idea is, if the club is not in the list they are taken to an Add/Edit form that opens up in Add mode.

[Micron]

maybe try the MoveSize method. IIRC, it's relative to the database window and not the screen so that should work for you.
MoveSize(Right, Down, Width, Height) All of the parameters are optional, so you don't have to worry about width or height if not needed.
The values are in Twips (I think about 1440 per inch).

[bbilotta]

thanks Micron. i research the "MoveSize" method.