 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2005using sub forms on tabs
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? Make sure that the master/child links are properly set for the subforms. >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 [quoted text clipped - 4 lines] > show > me an example? 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. > 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 [quoted text clipped - 3 lines] > any Ideas on how to get this to works or is there a web sight that can show > me an example? How do i tie the combo box to the sub form so that the sub form will show the corrispnding record? > 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 [quoted text clipped - 7 lines] > > any Ideas on how to get this to works or is there a web sight that can show > > me an example? 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. > How do i tie the combo box to the sub form so that the sub form will show > the corrispnding record? [quoted text clipped - 10 lines] >>>any Ideas on how to get this to works or is there a web sight that can show >>>me an example? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.