combo box not working

[amorrison2006]

Hi there

I am trying to use a combo box to filter my data in a form.

I only have one table and one form.

There are five fields.

I have a client and then with in a client I have orders.

Both of these are seperate fields.

I might two orders which would represent two records.

I want the combo box (which is also on my form) to be able to filter
down to see just a selected client.

I have tried to use the Event procedure for the After_Update using but
it doesn't work for me,

Please help,

Thanks in advance,

Andrea

 

[Jeff Boyce]

What you described sounds more like a spreadsheet than an Access table.

A more common well-normalized table design for clients/orders would be to
use one table for client information, one table for order information, and a
third table for order detail information (see the Northwind database sample
that comes with Access).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[michelleumich]

Hi there

I am trying to use a combo box to filter my data in a form.

I only have one table and one form.

There are five fields.

I have a client and then with in a client I have orders.

Both of these are seperate fields.

I might two orders which would represent two records.

I want the combo box (which is also on my form) to be able to filter
down to see just a selected client.

I have tried to use the Event procedure for the After_Update using but
it doesn't work for me,

Please help,

Thanks in advance,

Andrea

I'm actually having the same problem. My combo box has many fields
though. I'll keep an eye on this thread.

 

[amorrison2006]

Hi Jeff

It's not clients orders im really looking at......

I have a client who has accounts.......i want to filter by client. I
view my data in the form in a tabular form.

I just want a simple (not simple for me because I've spend hours
trying to get it to work) combo box to filter down by client.

I then plan to do lots more but there is so many posts for individual
people that it's hard for me to change they're examples to suit my own
data.

Please help......

Andrea

 

[Jeff Boyce]

I can tell you how to do something, but I don't understand enough about your
situation to have any sense if it will help you or cause you more trouble in
the long run.

Since you only want to filter this list by client, have you considered
exporting the data to Excel and using the filtering there?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[amorrison2006]

Hi Jeff,

This database will be used to send automatic emails, etc. It will
also be used as a real-time monitoring tool for many, many
users..........

Excel does not update in real-time and sharing such a database would
not work.

I dont think I can explain it any simpler.......I have one form with
the source being my table (i have only one table)

I added a combo box....tried to set the filter and it does work.

Can you help with the combo box or not?

Thanks,

Andrea

 

[Jeff Boyce]

Andrea

Based on your description, you seem to have already determined how you are
going to do this.

Put a combo box (unbound) in the header of the form. Use a query to get a
list of clients as a source for the combo box.

Use a query to get the data that fills your form. Modify that query to look
to the contents of the form's combo box as a selection criterion.

In the combo box's AfterUpdate event, requery the form.

(and I still question whether your data is organized to take advantage of
Access...)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dan Neely]

Andrea

Based on your description, you seem to have already determined how you are
going to do this.

Put a combo box (unbound) in the header of the form. Use a query to get a
list of clients as a source for the combo box.

Use a query to get the data that fills your form. Modify that query to look
to the contents of the form's combo box as a selection criterion.

In the combo box's AfterUpdate event, requery the form.

(and I still question whether your data is organized to take advantage of
Access...)

If the data is layed out to us an FK to reference the client to the
order, you can do this without having to write a query manually. Put
the order display in a childform and bind the clientID between the
combobox and the subform.

 

[Dan Neely]

Andrea

Based on your description, you seem to have already determined how you are
going to do this.

Put a combo box (unbound) in the header of the form. Use a query to get a
list of clients as a source for the combo box.

Use a query to get the data that fills your form. Modify that query to look
to the contents of the form's combo box as a selection criterion.

In the combo box's AfterUpdate event, requery the form.

(and I still question whether your data is organized to take advantage of
Access...)

If the data is layed out to us an FK to reference the client to the
order, you can do this without having to write a query manually. Put
the order display in a childform and bind the clientID between the
combobox and the subform.