Form Pop-Ups

[spock1971]

Guys

I've built a database and now need to add more fields. The screen is alreday full so I want to pop-up a new form just to capture these new fields and then go back to the main form.

However, I can't get the 2 forms to link together. The new form is opened by a form open button.

I basically want the users to enter a car registration number involved in an accident, then click the 'other vehicles involved' button to open a form to populate with multiple vehicle data. When finished, close the form and finish entering the incident details but remember the data to save later on.

 

[Oldsoftboss]

Base the pop up form on a query of info using the table on the main form. In the record set of the query, include the primary key, info you want to show and then the fields you want filled in.

In the On_Click event, save the record and then open the popup form using where criteria:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenForm "PopUpFormName", , , "PrimaryKey= " & Me.PrimaryKeyName

Dave

 

[Oldsoftboss]

On second thoughts, you need to normalise your tables, create a related table and populate it with the primary key from the main form. This way, if you have one vehicle or 10, you can add as many as you like.

 

[RuralGuy]

You might also want to examine the TabControl. You can use it on a form when you run out of real estate for the controls needed.

 

[spock1971]

Cheers All

Not a brilliant Access user and some of the suggestions I couldn't work out.

However, I added the new fields to the query I was populating via main form and when I popped up the new form, I sent the related values to the new form, and then when closing the pop-up, sent the values back to the main form again and it appears to be working.

 

[GamingResources]

Instead of using pop-up forms, good idea...

What about using a tabs? You could name the tabs based on the type of information on the car, incident, etc...taking the user filling the screen out through the proper steps through the TAB control and data verification aspects (i.e.: if null, OnExit, AfterUpdate, etc..etc..etc..)

Using tabs (available through the access menus, no directx add-in), this may work a bit better for you. Just a thought...