(asked in the Newsgroups) :
Well, I thought I had finally figured out how to get my form to work the way I want it to. Meaning, on my form I want the following phone types to display as defaults:
All my *hidden* fields have a back color of hot pink. I started doing this a long time ago so I could keep track of which fields I have hidden when in Design View. (Fortunately, no one has ever asked me to design a form in hot pink or I would have to change the backcolor of my *hidden* fields!)
To do this you would need a combination of a main form\subform (however, no one will see it), a table to hold Phone Types and Allen Browne’s code.

Allen Browne’s code copies existing child records with its main record to a new record. You want to copy new child records with or without main record. To make the code *work for you* your child records are going to need a trigger, hence the need for a Phone Types table.

In the example below the subform has been set-up to show five rows, the same as the default Phone Types. To adjust the Phone Type defaults check/uncheck the Add check box. To display the default Phone Types in a specific order simply adjust the number in the Order column.  The Sort Order column controls the order in which they display in the Combo Box on the Client Profile Form.

Click here to download a sample file displaying the technique.
Auto-Add new child records when adding a new record on Main form...
The add check box is your trigger...
Why is that pink?  Can I remove it?
The difficult I do immediately, the impossible takes a little bit longer.
Tips (Main)
Let your Client customize the form labels
Linking Subforms to an Unbound Control(s) on the Main (Parent) Form
Customize your Main Menu or Switchboard
Simple Bar Chart using Shapes
Simulate a Drop Down box (not a Combo Box) as seen on Web Pages
Implement a Log-On form to control what the User sees
Make Controls resize with a Form
Switch Windows
Assign *Permissions* based on Users Levels
New User Form
Add *Favorites* to a Continuous Form
Custom Record Selectors
Searching Records
Drill Down (for Continuous Forms)
Highlight Required Controls (End-User Defined)
It doesn’t work. If I decide to add a new Client/Company I want it to automatically display the default phone types (which I would also like to be able to select the defaults to display) AND I don’t like subforms.
Click to send feedback...
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.