MS Access question

AsSiMiLaTeD

Is there a way to filter a form based on a value selected in a combo box? I have a form built on a table, and one of the fields in that table is employee ID.

So basically, I'd like to select a name from the employee drop down list, and then only display values on the form that are for that employee.

Keep in mind that there is a one to many relationship between employee and records, so one employee may have 10 records assigned to them that they need to update.

Any thoughts?

PolkThug

Yes, it can be done.

Sami

SELECT * FROM 'TableName' WHERE EmployeeID = x

E-mail or PM me and I can help further if needed.

PolkThug

Make a combo box, with a query the employee ID# as the 'Row Source'.

then....

PolkThug

You'll need to make a macro and assign it to the box as well (im jumping around a little bit)

PolkThug

The macro

PolkThug

The macro code. apply your own names here of course

This goes in the Where Condition:
[Forms]![Form-Start]![Combo-Internal Num]=[Query-Client Information]![INTERNAL_A]

PolkThug

So, in my example, a combo box is made on a 'Starting Form', you hit the drop down for your #, then it goes to the form with your info.

PolkThug

This is how it looks at first, if you start typing in a number it will try to match it, or select from a list. The list is populated by your query. The macro opens the form with your detailed info records.

Sami

Looks like you're using the ID as a combobox item, I would use the name and embed the ID into the tag property.

AsSiMiLaTeD

PolkThug wrote: »

The macro code. apply your own names here of course

This goes in the Where Condition:
[Forms]![Form-Start]![Combo-Internal Num]=[Query-Client Information]![INTERNAL_A]

Can you help me out with this part a bit? Is everything after the = the values in the main form that you're opening?

AsSiMiLaTeD

No, that's not it....

AsSiMiLaTeD

I think I figured it out, will report back...

PolkThug

= [Name of query to extract Employee ID]![Name of Employee ID field on the form that has the detailed info]

AsSiMiLaTeD

NICE - that did the trick! CP to the rescue again! Thanks for your help!

Sami

May I ask what your application is for? You might be better off with SQL Server 2005 Express and VS Express if the app grows in functionality.

AsSiMiLaTeD

This is just a small Access database that'll probably never contain more than a few hundred records. However, our area is looking for an Enterprise reporting app. Right now most of our departments are using either Crystal or SQL RS - got any thoughts along those lines?

For some reason, they decided to have me lead the charge, even though I'm one of the least qualified people to do so.

ben62670

PolkThug wrote: »

This is how it looks at first, if you start typing in a number it will try to match it, or select from a list. The list is populated by your query. The macro opens the form with your detailed info records.

Dude you are so good at script you should do an access database about how many Polkies are/have gang raped women due to the TBT.
Sorry I shall resist.

AsSiMiLaTeD

Wtf?

engtaz

MS is offensive.

engtaz