Software

Ask something
Discussion Locked

Opening a new form

0 helpful
6 replies

by jimmy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

6 replies

by karpi

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

by jimmy

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

by nikki96

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

by bristar

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

This discussion is closed to new replies.