Help with code for Access 2007

[tingler0]

Please excuse me i am new at doing code for access and i am trying to teach myself, i have a form of which is also linked to a query for company contacts. in the form when the shipper is being entered it will query from the query of company contacts when the correct company name is selected i would like to have the form populate the shipper contact name, phone, address, city, state and any attachments that have previously being saved the shipper name is a combo box on the form and found the query i need for the form to generate the other information and i believe that i need to add a code to each field to have the informaiton popluate but i think i have something wrong because the query will work but not the code here is the code i have please let me know if i am going about it all wrong or if am just missing something.

Private Sub Shipper_Contact_BeforeUpdate(Cancel As Integer)
db As Recordset
    rs
        SELECT CompanyContacts.Business_Phone & _
        FROM CompanyContacts & _
        WHERE(((CompanyContacts.Company) = [Forms]![TripInfo Form]![Shipper]))
 
End Sub

thanks in advance
Beverly