using sub forms on tabs

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top