Hello all,

I have an access 2010 conracts web db where i have a 'batch' field to group clients on a contacts table.

I have a combo box where upon batch selection from the list all contacts belonging to that batch# will be displayed along with a few records like their contactname, company, email etc. The form should not display anything until a selection is made from the combo box if possible.

So far I have been trying to get the combo box list to remove duplicate batch numbers but no luck either

Settings for the cmbBatch are:
Control Source: Batch (from main table contacts)
Row Source: Contacts
Row Source Type: Table/Query
Limit to List: Yes
Inherit Value List: Yes
After Update: GOT NOTHING HERE

The settings for the form itself are:
Record Source: Contacts
On Current:
On Load:

If it helps this what the forms looks like now http://farm6.static.flickr.com/5284/...1147a590ec.jpg

I am new to access and downloaded a few example dbs but didnt help much, so ANY help will be very much appreciated!!

which combobox....
BTW why don't you make a query to populate the combo instead of directly interfacing the underlying table

Hi, the combo box im referring to is named cmbBatch and is in the header section of the form (http://farm6.static.flickr.com/5284/...1147a590ec.jpg)

I have this query to populate the contents in the combo box list row source:
Only thing I havent been to complete is the required afterupdate code. Any ideas or suggestions will go a long way =)

Works fine now, finally figured out the afterupdate macro. For those interested this is the code I used:

http://farm6.static.flickr.com/5170/...cdb99715c5.jpg