Modal/NonModal forms

According to the ancient tomes of VB 6 help, once a form has been shown as
one type (modal or nonmodal) it's type cannot be changed. I can certainly
understand why, but it would also certainly be nice if it could.

My situation is the ability to add table entries on-the-fly. For example,
suppose you are keying-in an invoice (a/r or a/p) and you need to add a new
customer or vendor. It's easy enough to call the maintenance form for that
corresponding table from the invoice maintenance form, and call it as modal,
since you want to add the new customer or vendor to the lookup list on the
invoice form when the user is done. However, suppose that the table entry
being added might also need sub-table information added. Like a G/L
account, for example. You'd need to call the G/L account maintenance form
in a modal state as well, so that likewise, when the user had added the new
G/L account, it will include it in the list on the customer or vendor form.

Currently this seems to be impossible, and limits on-the-fly adding of
records to table to simple data tables. Running the code in non-modal mode
would not be able to accomplish the needed step of including the new entries
in their lists.

Is there some kind of simple work-around that I've missed?

I realize that even if you were able to change the modal status of a form
via the API or something, logically, it would then continue to run the code
in the calling form before you could even open another modal form, so
perhaps this is the reason it's just not do-able?

Bill "Frisbee" Hileman


.

Relevant Pages

  • Re: PaulD - please help!
    ... Paul for replying and giving such detailed instructions - they are ... wanted to create a drop-down of vendors in the vendor heading and then a list ... cascading combo box type layout (found the synchronize two drop-down lists ... Then make selection from second box and have ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Why is this an error?
    ... All of which have either a value list or a table of selections ... information in it to make the filter work. ... cboxbranch has a table that lists just numerical branch #'s and branch ... cboxvendor has a table that lists just numerical vendor # and vendor ...
    (microsoft.public.access.formscoding)
  • Re: Why is this an error?
    ... All of which have either a value list or a table of selections ... information in it to make the filter work. ... cboxbranch has a table that lists just numerical branch #'s and branch ... cboxvendor has a table that lists just numerical vendor # and vendor ...
    (microsoft.public.access.formscoding)
  • Re: PaulD - please help!
    ... a list of literature will appear below relating to that vendor. ... You then talk about drop down lists and making the first one drive the ... :> dim ContactEmail ...
    (microsoft.public.access.dataaccess.pages)