form Tab Control referencing same record

  • Thread starter Thread starter Meg
  • Start date Start date
M

Meg

I have a form used to input data into a table called
Transactions. The form has three tabs at the top each
pulling up a subreport.
The first Tab called "Transaction Info" has the
information needed on all transactions.
The second tab called "Service Info" has the info needed
for service transactions.
The third tab called "Retail Info" has the info needed
for the retail transactions.

The user will fill out the Transaction Info form and than
select either tab to finish filling out the remaining
info depending on the type of transaction. The
information entered into the form will populate the table.

It works great with one Major Exception - I need it to
stay on the same "TransactionNumber" without entering the
transaction on each form.

Can anyone help me?

Thanks in advance - you guys are GREAT!

Meg
 
Hi Meg!

Base your form on the Transaction table. Delete the Transaction subform on the
first tab and place the fields that were in the Transaction subform directly on
the first tab. Make sure to include the primary key. Go to the second and third
tabs and make sure the Link Master and Link Child properties for each subform
are set correctly.

The second and third tabs will now track the first tab where they will be at the
same transaction number as the first tab.
 
Thanks so much!

Yes, kind of works. I can't completely create the first
record. It completes the table after the first tab but
won't populate from the 2nd and 3rd tab. Any ideas on
that?

Other problem once I did it that way is that now some of
the fields on the first tab are bleeding through to the
second and third tab,ie you can see them right in the
middle of those forms - any ideas on that? I had
actually done this in the beginning but because of the
bleeding problems went to the subform on the first tab as
well.

Thanks for your help BIG TIME!

The other problem is that if I
-----Original Message-----
Hi Meg!

Base your form on the Transaction table. Delete the Transaction subform on the
first tab and place the fields that were in the
Click to expand...
Transaction subform directly on
 
<<some of the fields on the first tab are bleeding through to the second and
third tab>>

When you want to create fields on a tab control, you must first set the
background to Normal rather than Transparent. Transparent is what causes the
"bleeding".

Please explain your first paragraph in more detail!

Steve
PC Datasheet
 
Once again, thanks so much for your help

I'm using this form to populate a table. I fill out the first tab which has information which applies to both types of transactions, retail and service. Then I pick the retail tab for example and fill in that information. All three tabs have information which populates the same table "transactions". After I fill out the form and flip back to the table, only the information from the first tab has populated and the second tab didn't populate. I know I'm referencing the record correctly because I have a formula on the second tab which relates to information on the first tab, I'm just not populating from the second and third tabs. Hopefully that explained the problem clearly

Meg
 
You have subforms on tabs 2 and 3. Go to design view of your form and the Retail
tab, click on the subform control, open properties to the Data tab and make sure
the source object property is the Retail subform. Also make sure the LinkMaster
and LinkChild properties say TransactionID. Go to the Service tab and go through
the same check. Close the main form.

Open your Retail subform, open properties, go to the data tab and make sure the
recordsource is either the Transaction table or a query based on the Transaction
table. Do the same for the Service tab.

After all the above, data entry on tabs 2 and 3 should populate the Transaction
table.

Let me know how you made out!

Steve
PC Datrasheet


Meg said:
Once again, thanks so much for your help.

I'm using this form to populate a table. I fill out the first tab which has
Click to expand...
information which applies to both types of transactions, retail and service.
Then I pick the retail tab for example and fill in that information. All three
tabs have information which populates the same table "transactions". After I
fill out the form and flip back to the table, only the information from the
first tab has populated and the second tab didn't populate. I know I'm
referencing the record correctly because I have a formula on the second tab
which relates to information on the first tab, I'm just not populating from the
second and third tabs. Hopefully that explained the problem clearly.
 
That didn't seem to work but with your help about the
fields bleeding through, I was able to recreate the form
without subforms and its working now. Thanks so much for
your help!!!
 
Back
Top