General discussion

Locked

Opening a new form

By jimmy ·
Hi there,

I am creating a call management system database and would like to do the following 2 forms.

Form 1 - Call Details
Form 2 - Third Party support Companies

On Form 1 (Call Details) - I would have a check box to indicate wether the call has to be dealt with by a third party support company.
Therefore, if i tick the check box i would llke the third party (form 2) to appear at the right hand side of form one or even as a new form, Doesn't really matter, just as long as i can enter the third party support company details.

ANy help on this matter vey much appreciated.

Thanks to all who reply in advance

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Opening a new form

by Karpi In reply to Opening a new form

Hello,

I think you will have to use VBA-Programming.
In a Module you can open a Form with:

docmd.openform "Formname"

Before I can give you more details, I need more details:
- Structure of the database
- Relations of the tables etc


HTH
Karpi
<fluctuat nec mergitur>

Collapse -

Opening a new form

by jimmy In reply to Opening a new form

I got a new form to come up by doing the following:
Create a Macro (openForrm)
Right click and select properties of the third party support field in the call_Details form then select the EVENT Tab select the after update cell and insert the macro name and form name to open.

I would still like to know how to split the form so that i can view both at the same time though.

Cheers for the reply

Collapse -

Opening a new form

by nikki96 In reply to Opening a new form

In VB(A), I don't think you can't have two forms have focus at the same time. I'd suggest having the checkbox check event change the visibility of the info you want shown on the same form.

I have a form (frm1), a checkbox (ck1), and a content label (content), then this is what I have.

Private Sub ck1_Click()
If ck1.Value Then
content.Visible = True
Else
content.Visible = False
End If
End Sub


If you really want the other form to show up, just change that to

Private Sub ck1_Click()
If ck1.Value Then
frm2.Show
End If
End Sub


HTH

Collapse -

by jimmy In reply to Opening a new form

Poster rated this answer.

Collapse -

Opening a new form

by Bristar In reply to Opening a new form

It sounds to me like you would have an easier time if you kept the information on the same form. Start with the 3rd Party information fields set to not Visible and place code behind the checkbox that turns the Visible setting to true when the box is checked. For most any Microsoft language you are looking at some code like:

If me.CheckBox1 = True Then
txt3RDPTY_NAME.Visible = True
txt3RDPTY_ADDRESS.Visible = True
Else
txt3RDPTY_NAME.Visible = False
txt3RDPTY_ADDRESS.Visible = False
End If

Collapse -

by jimmy In reply to Opening a new form

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums