Search Form

[GarageFlower]

I have a database im working on at work

As you can see there is a project contacts table.

I also have a form which displays what projects (project general table) have which human resources TUPE data (Human Resources Tupe table).

I have set up the relationships between the tables allready.

What i need to do and am unable to do is to create a form which comes up first says "please chose your post title from the drop down list". This will then show a list of the post titles from the project contacts table.
The person will then chose their own post title (dgsa-sec1 for example) it will then open up the "project general form" displaying only the projects from the project general table relating to the post title they have selected.

Could you please do this for me in my uploaded database and then tell how i can do it myself for future reference.

Many Thanks

 

[ColinEssex]

You can actually do this yourself

a search of the sample databases will locate a Db called QuickSearch which (modified) will enable you to select the job titles using a ListBox. After selecting - you can add the projects by using a query based on the criteria selected.

Col

 

[GarageFlower]

Cheers dude. just tried what you suggested but to no avail...

i created a new form with a list box...
But it didnt come up as a drop down list like i suggested.

Plus i havent got a clue what to do with once ive selected the post title i want to dispaly the projects for.

Please help

Dont suppose you could do it for me and then explain it too me.

Im rubbish at this

Many Thanks

 

[ColinEssex]

here's the search database

http://www.access-programmers.co.uk/forums/showthread.php?t=65331&highlight=quicksearch

Col

 

[GarageFlower]

dude i have allready looked at it

call me stupid, but that isnt any help to me

 

[GarageFlower]

Sorry mate but im not even sure where to start with this.

Sad i know, but please please please could you help.

Would you be able to do what i have asked, and then explain in lamens terms for me

It would be much appreciated

Thank you

 

[GarageFlower]

Could Someone please help me or show me how to do this

Thank You

 

[GarageFlower]

You can actually do this yourself

a search of the sample databases will locate a Db called QuickSearch which (modified) will enable you to select the job titles using a ListBox. After selecting - you can add the projects by using a query based on the criteria selected.

Col

I have now spent 6 hours fiddling about with this and am no further with my quest.

The example you have uses only one table.

Im using four at the moment but will be using many more in the future.

Will someone please explain to me how i can do this

Im so frustrated with this

 

[trucktime]

Database

GarageFlower.

I looked at your mdb and did a little bit of work on it.
I added a field to the Project General Table and made a form
(frmMain) with a Combo Box.
This is probably what you want, open the form in design View
and look at the code, it is fairly simple.

One good advice, don't use spaces in table- and fieldnames,
at some point it may cause problems.

Good Luck.

 

[GarageFlower]

Dude

I am soooo gratefull


Indeed that is how i want it too work

But alas , im going to be adding another 25 tables and whole lot of data to this

I really needed it to work just like the one you uploaded but with the Post Title field still in the Project Contact table

I say this because this is only the start the db is going to get so much more complicated

 

[ColinEssex]

But alas , im going to be adding another 25 tables and whole lot of data to this
I say this because this is only the start the db is going to get so much more complicated

Personally, I would get all the tables done first, then get the relationships sorted out. Then worry about the forms and the like. Incidentally, 25+ tables may indicate that your design may be suspect (it may not of course) but that does seem alot to me

The example you have uses only one table.

Im using four at the moment but will be using many more in the future.

Your forms should be running via queries anyway, not direct to the table.

Col