Re: Opening a second instance of a form - Access97

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 01/02/05 

Date: Sun, 2 Jan 2005 08:01:56 -0500

See whether what Allen Browne has at
http://members.iinet.net.au/~allenbrowne/ser-35.html helps. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"WSF" <someone@microsoft.com> wrote in message
news:I1OBd.4456$mo2.258890@news.xtra.co.nz...
> I have read the Help file and searched Google and Access sites for info
> on this problem, but still cannot get it to work.
>
> Firstly I a job info form (Pop-up - Modal-No, Has Module - Yes). In that
> form there may be a reference to a previous job, in a text box
> [txtPreviousJobNo] (if no previous it reads "0").
>
> By double clicking that text box (where it holds a valid previous job
> number) I want to open a second instance of the same form with the data
> of the previous job.
>
> The first instance of the JobInfo Form is bound to the master data table
> and is initially opened from another main form by:
> DoCmd.OpenForm "frmJobInfo", , , "JobsNo = " & Me!txtJobNo
> where [Me!txtJobNo] is a current job number. That works fine.
>
> Then I have:
> Public PreviousJobNo As Integer
> Public frmMulti As Form
> declared in a separate Module
>
> In the [txtPreviousJobNo]text box in the JobInfo form Double-Click event
> I am trying:
>
> Set frmMulti = New Form_frmJobInfo
> frmMulti.SetFocus
>
> This opens the second instance of the form - great, but - it displays
> the data from the first record of the master data table.
>
> How can I have the second instance display the data based on the job no
> in the [txtPreviousJobNo] text box? Then I have two forms open each
> displaying the current and the previous job?
>
> I have read of the implication's of using multiple instances of forms,
> closing them etc., but have my own ideas on handling that assuming I can
> get them to open correctly for me in the first place.
>
> TIA
>
> WSF

Relevant Pages

  • Re: Multiple Instance of a Form
    ... Check the following code that opens a form with a subform 3 ... On the second instance, it changes the subform's sourceobject to a ... Dim frm As Form ...
    (microsoft.public.access.modulesdaovba)
  • Opening a second instance of a form - Access97
    ... Public frmMulti As Form ... This opens the second instance of the form - great, ... How can I have the second instance display the data based on the job no ...
    (microsoft.public.access.formscoding)
  • Re: normal.dot problem for multiple instances of Word 97
    ... When you say you click on the icon for another Word document, ... instance of Word opens, what icon are you talking about? ... Definitely install both Service Releases: ... opening a second instance of Word (and with it, ...
    (microsoft.public.word.application.errors)
  • Re: Access 2007 Custom Menu Bars
    ... When I mess with the Access 2007 Ribbon it ... sometimes opens a second instance of Access which takes and will not ...
    (comp.databases.ms-access)