Dependant field/lookup

[aaaaaaaccess]

I have been away from Access for some time, forgive me if this is waay to easy to be posting about:

i have a tables: Enquiries, Customer and Contact.


Customer has 1 or more Contacts (people who work for the customer)




Enquiries has a single customer (customer_ID) and a single contact (contact_ID)


How do i make it so that Contact is selectable in an Enquiries form but is restricted based on the selected Customer??

[CJ_London]

google 'cascading combo's' for a number of ways to do this. But in principle you need two combos, one for the customer and one for the contact

the rowsource for cboCustomers would be for example

SELECT CustomerPK, CustomerName FROM tblCustomers

the rowsource for cboContacts would be

SELECT ContactPK, ContactName FROM tblContacts WHERE CustomerFK=[cboCustomers]

then in your cboCustomers after update event you would have

Private Sub cboCustomers_AfterUpdate()

    me.cboContacts.requery
    me.cboContacts=Null

End Sub

change all names to suit your actual table, field and control names

[aaaaaaaccess]

Ahh.. you're jogging my memory here. Thanks Ajax, this ought to be enough for me to work with!

[orange]

If you need some video reinforcement, then these may help

http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

[aaaaaaaccess]

Hi orange, yes, those were useful, I've got it working now. Thanks!