Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

subcontractor database

Forum home » Delegate support and help forum » Microsoft Access Training and help » Subcontractor Database

Subcontractor Database

ResolvedVersion 2007

Sophie has attended:
Access Introduction course
Access Intermediate course

Subcontractor Database

I am trying to create a form so that i can have a drop down box for trade description and then a second one for subcontractor, i want the subcontractor box to filter from the trade above, so if i select bricklayer from the trade description drop down, then only the bricklaying subcontractors are available for selection in the subcontractor drop down?

RE: Subcontractor Database

Hi Sophie, thanks for your query. There's a template to do just that here:

http://blogs.office.com/b/microsoft-access/archive/2009/04/03/template-demonstrates-how-to-synchronize-combo-boxes.aspx

...but be warned, it is fiddly and involves either macros or VBA.

Hope this helps,

Anthony

Mon 28 May 2012: Automatically marked as resolved.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.