Search results

  1. J

    Query based on current record

    ajetrumpet, Thanks a lot, thats exactly what i was looking for. James
  2. J

    Combo list based on current record

    Thanks Zigzag. Sadly it is still not working. Is it because you cant reference to a field that has just been editted on that record? Here is my current query: SELECT Company_Addresses.CompanyAddressID, [AddressName] & " (" & [Town/City] & ")" FROM Company_Addresses WHERE...
  3. J

    Combo list based on current record

    I am designing a contact management system and have hit a bit of a wall. I am farily new to Access so please advise if I am going about this the totally wrong way. I have three tables; Contacts, Companies, Company_Addresses Contacts: ContactID (P) CompanyID OfficeName Companies: CompanyID (P)...
  4. J

    Query based on current record

    I am designing a contact management system and have hit a bit of a wall. I am farily new to Access so please advise if I am going about this the totally wrong way. I have three tables; Contacts, Companies, Company_Addresses Contacts: ContactID (P) CompanyID OfficeName Companies: CompanyID (P)...
Back
Top Bottom