using sub forms on tabs

R

ron csumb

I have 5 tabs one for each credit card. on each tab is a subform that is
suppose to show the redcords for that credit card. the subform is a
contiuous form.
I did get the first form to work, but unable to get the rest to show the
records on the rest of the tab and subforms.
any Ideas on how to get this to works or is there a web sight that can show
me an example?
 
P

Pat Hartman\(MVP\)

Make sure that the master/child links are properly set for the subforms.
 
D

David C. Holley

Why not add a combo box that lists the credit cards and tie the subform
to it? When the combo box is change, the subform would display the
appropriate records.
 
R

ron csumb

How do i tie the combo box to the sub form so that the sub form will show
the corrispnding record?
 
D

David C. Holley

Quite tired from a 12-hour day. If my brain happens to be working, you
would set the linkMasterField of the subform to the ComboBox and the
linkChildField to the appropriate field for the subform. If its a
situation where your reusing the same subform to display records from
different queries or tables, you'll need to add code in the comboBox's
AfterUpdate event to modify the subforms recordsource. Shouldn't be too
difficult.
 
Top