Pop up Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all,

Have read through all the posts I could find about forms and pop-ups and all
seem to be a little advanced for me to understand what I should be doing.

What I am trying to do is have a primary form "Centre information" and want
anoter form "Council information" to pop up when the "council name" field is
clicked in the primary form.

Any help appreciated but please keep the language simple if possible.

Cheers,
Matt
 
Hi Matt

Create the form form you need and set the PopUp to Yes - Open the properties
box and the PopUp option is at the top of the "Other" column

You will need to play around with the form until you get the look and
functionality you need but have a go and see what you can do.

Hope this helps
 
Sorry - forgot to add

Put this behind the on click event of the

Private Sub council name_Click()
DoCmd.OpenForm "Council information", acNormal, "", "", , acNormal
End Sub

Oh and I would remove the space from fields names if you can as it will
prevent a few problems in the future
Council information should be Council_information
Or
CouncilInformation

Hope this helps
 
Thanks Wayne,

Those steps managed to bring up the up the council_information form but just
a couple of further problems:

1) The council information form loads behind the primary form. Can this be
set so it loads in front?
2) When the council form loads i want it to load with the corresponding
record to that which was clicked on in the primary table. Ie. user clicks on
the name of the council in the primary form and the council_information form
loads with the corresponding council information.

Any further help appreciated.

Cheers,

Matt
 
Wayne,

Have just noticed a couple of other issues post the changes you suggested:
- When the Primary form loads in form view, the tool bar where I used to
click to change to design view is now gone. The save option is also now
always shaded out and even when fields are edited it does not give the option
to save.
- Secondly I can now no longer add a new record. The option in the control
is still there and a new record will load up. The problem comes when I try to
input data into any of the fields from the primary table "Centre_raw_data".
It will not allow me to type anything into these fields and yet I can edit
any of the fields that come from linked tables and appear in the same form. I
have checked the allow edits fields and all seem to be set to yes so I fail
to see why it is now happening. Any ideas?

Cheers,

Matt
 
Hi Matt
1) The council information form loads behind the primary form. Can this be
set so it loads in front?
Click to expand...

If you set the subform properties to be Sub Form = Yes this will keep it in
front of your main form
2) When the council form loads i want it to load with the corresponding
record to that which was clicked on in the primary table. Ie. user clicks on
the name of the council in the primary form and the council_information form
loads with the corresponding council information.
Click to expand...

For this to happen you need to ensure that the child and master fields are
linked. You need to “tell†access that the records in each form are related
to each other.
Open the main form in design view and open the properties dialog box.
Click the edge of the sub form and in the data column of the properties box
you will see
Link Master Field
Link Child field
These 2 fields need to have the same data - normally this would be the
primary field of the main table/form and the linking fields in the sub
form/table - you can set this up in the relationship window.

It seems to me that for the situation you have given would be a good place
to use a Tab Control on your main form with the Council details on the Tab.
Set up the child and master fields 1st and this may be a simpler way forward.
Press F1 and search on Tab Controls
 
Wayne,

Have just noticed a couple of other issues post the changes you suggested:
- When the Primary form loads in form view, the tool bar where I used to
click to change to design view is now gone. The save option is also now
always shaded out and even when fields are edited it does not give the option
to save.
- Secondly I can now no longer add a new record. The option in the control
is still there and a new record will load up. The problem comes when I try to
input data into any of the fields from the primary table "Centre_raw_data".
It will not allow me to type anything into these fields and yet I can edit
any of the fields that come from linked tables and appear in the same form. I
have checked the allow edits fields and all seem to be set to yes so I fail
to see why it is now happening. Any ideas?

Cheers,

Matt
 
Back
Top