Combo Box List display HELP!

[ehabo]

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 web form with a combo box of batches where upon a 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 understand DISTINCT could work?

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


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

[RuralGuy]

Your RowSource for the ComboBox should be a Query that you create with the Query builder. Have you played with the Query Builder yet?

[ehabo]

Thanks

Yes I have very little experience with the query builder but have tried many times for 'row source' and 'after vavlidation' with no luck.

If you have knowledge to walk me through what needs to be done to configure it for its designed functionality i would truly be thankful

I have a web form with a combo box of batches where upon a 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.

[RuralGuy]

Create a query that returns what you want. A table returns all of the fields which are probably not needed for your ComboBox. Go to the RowSource of the cbo and press the "..." button on the RowSource property and it will ask if you want to create a query. Answer yes and then save the query as a starting point. Open the query and switch to SQL view nad post that here so we can see it.

[ehabo]

Thanks for the helping hand

[RuralGuy]

Please get to the query builder from your cbo RowSource property "..." button. This is not it. Then switch to the SQL view and copy and past that to a post.

[ehabo]

When i try to switch to sql view i receive this warning




Datasheet view then displays theses results and the only other view option i have is design view.

[RuralGuy]

This is just a table with two fields in it? Weird! It also looks like you might be using Lookup Fields: http://www.mvps.org/access/lookupfields.htm

[ehabo]

I have a web form with a combo box of batches where upon a 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.

Settings for the cmbBatch are:
After Update: need help with this code please!

If it helps this what the forms looks like now

Thanks i have managed to complete everything just cant figure out the afterupdate code to display my subform with batch members and a few details like name, email, phone etc. after the combo box selection.

Any suggestions or help will go a long way!

[kahr3n]

I dont know if I got it right but i assume you just need to know where the afterupdate option can be found? Look into the image. If you are in Design/Layout view, you have to navigate on the Design tab then in Tools group, click Property Sheet.
On the Property Sheet, head up to Event tab. And finally you will find the After Update...Click on (...)

[ehabo]

And finally you will find the After Update...Click on (...)

Thanks, but i am actually just struggling with the afterupdate code. Any ideas on how i can get it to display only the records with a same batch number from the combo list?

[ehabo]

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