Designing a form with a header

[mbenton]

I'm running into a few challenges with a form. I'm trying to design a form with a header. My header has a few fields i.e., date, period, and user name. These fields are located in one table called Headertbl. Data from the main form comes from my parts table, "Partstbl", each part has a part number, model number, cost, etc... which are all fields in that table. I don't want a header for each part but I want to select the Period (a drop down combo box) which changes the header on my form and also brings up all parts associated with that period. In other words when I select my period in the header I want it to do two things, 1. change my form header, and 2. group all parts for that selected period. Any advice? Thanks.

[ranman256]

Put all the items needed for the header in the combo box. When user picks it, apply the combo columns to the header boxes..

sub cboBox_afterupdate()
  txtBox2 = cboBox.column(2)
  txtBox4 = cboBox.column(3)
end sub

[mbenton]

Got it! Thanks ranman, very helpful.