Add a Tab on an Existing Form

[Rudy16]

Rudy here,

I have an existing form (Residents)that has 1 year's worth of dues on it and the user would like me to add 9 more years of dues to it. The Form is "Full" and I cannot place any more data entry fields on it without the need to scrool down.

I opened the Residents form, went into design mode, selected object, new, and selected Tabbed. It placed the object in the top left corner of my Residents form. I then went into properities and removed Page 2 and Page 3 tabs and renamed Page-1tab to "Dues". I saved the form and when I opened it, I expected a blank area to appear when I pressed on the "Dues" tab. Nothing happened.

My goal is to move the 1 years dues from the form to the "Dues" tab form area and add the other 9 years fields to it.

The Residents form is to have all data except for the dues and when the user clicks on the "Dues" tab, I want to display all 10 years dues fields for data entry.

I hope this is clear to all. Please advise.

Thanks,
Rudy

[Stan Mathews]

Re: Add a Tab on an Existing Form

I expected a blank area to appear when I pressed on the "Dues" tab.

It sounds to me like you expected a blank area to open covering the visible screen? A tabbed object saves space on a form by use of the tabs (multiple, not single).

When you select the first tab you see the objects on it. When you select the second tab, the objects on it become visible and those on the first are hidden.

We probably need more information to help you decide how to proceed. What tables and what fields are involved. I am thinking you are currently using one table with a field for each month to record dues?

[Rudy16]

Re: Add a Tab on an Existing Form

Hi Stan,
Thanks for the quick response.

Gave this issue some more thought and came up with a different senerio. Much cleaner and now working.

Thanks aghain, Rudy

[gschepp]

Re: Add a Tab on an Existing Form

What was your solution?

Hi Stan,
Thanks for the quick response.

Gave this issue some more thought and came up with a different senerio. Much cleaner and now working.

Thanks aghain, Rudy

[Rudy16]

Re: Add a Tab on an Existing Form

Rather the create 10 fixed years of data for which each year contains a Posting Date, a Check Date, a Check #, a Qtr Ending, a Current Year (yyyy), and an Amount and place it on a 2nd tab I decided to:

1) Adde an Auto Increment field called Client_mst_rec_no to my Client Master (main) table.
2) Assigned a Serial Value to the field thanks to Peter Greulich's instructions.
3) Created a seperate Table called Client_Child and included a Client_Child_Rec_No and added the other mentioned fields in the 1st paragraph.
4) Created a new Table Set using the Client and Client_Child table using the *.Rec_no's as a 1 to many link.
5) Created a new data entry form from the old one and included an embedded browse (Child Table) to the form.
6) Changed some code to accomodate the new set.

While this may seem like a lot of work, I now have a form that handles an infinite number of Dues Years and Quarters. I also inverted the sequence of the Child Table so that latest year and quarter loads on top.

I hope this is clear to you. If not, please let me know and I'll answer any other questions that you have.

Rudy from South Jersey