Parameter query with DropBox through Form

[dbalilti]

Hi.



So i am trying to make a Form where I insert a field (Say The Developer) through a drop box and then hit a button which will open up a query and show me the the Records with that developer.


How do i do this lol!

Ive seen some stuff on the internet, but none of them are really clear on how to actually do it. i know in the query im supposed to put the parameter as [field]![form]![dropBox] or something like that.

thats as far as i got, i dont know what to do in the form to make this work.



thank you for any help.

[alansidman]

This should get you started.

http://www.datapigtechnologies.com/f...earchform.html

[orange]

You could start with a blank form.
Now what do you need to do???
This is what you said

You said you wanted 
      to hit a button
             which will open up a query and 
                 show the records related to that developer

This what you will need, based on what you said
So you need a button with a Click event
which will open a query
that will Select records related to some developer???


Which developer??? Where will that info come from??? A dropbox... which dropbox?

What will be in the drop box?? Where will that data come from??

I think that's a bit of help to get you started.

Update/edit: I see Alan posted while I was typing.

[dbalilti]

Alright, so I watched the video, and it helped, but I stil have one problem.

When i run the Form, in the drop box i select a Developer, and I hit the Run Query button and the query pops up and shows me what I want, all the jobs with that developer. Now, when i try to change the developer on the form and hit the Run query button again, Nothing happens!

Why????

Can anyone help me!

[alansidman]

Did you remember to put a Me.Requery in the afterupdate event of the combobox?

[dbalilti]

Yes, I did remember, it still doesnt work. Any other ideas???

[alansidman]

Will probably need to see your db in order to diagnose. Suggest you upload with limited and non confidential data. To maximize viewers who can assist, suggest you save as a AC 2003 .mdb file. Run a compact and repair before zipping.

[dbalilti]

Will do, One problem though, the confidential information... I am trying to delete it, but it wont let me delete it! basically i have three fields with confidential information and they are shared (Relationship) Between two tables..

How do i get rid of those fields without ruining the database?

Funny that I run into problems because im trying to fix problems haha.

[alansidman]

Copy your data base into a new database and try to just change the data to something that is not confidential instead of trying to remove the fields. Removing the fields will probably corrupt the db.

[dbalilti]

BackUp4.zip
Okay, I only left 4 records to make my life easier.

I also noticed there is something wrong with my other Query (Sort By Unit) Because it stopped working for some reason when i removed most of the records and changed the names of the remaining few.

Any help would be much appreciated..

thank you

[alansidman]

Sorry, I cannot read your file at work. I will have to wait until I get home as I only have AC2003 here.

[dbalilti]

Alright. Thanks for your help!

[alansidman]

I can't be sure, but I think the issue has to do with table normalization. You should not have two identical tables. I understand why you did it, but it is contrary to relational database design. You should not be segregating your data by mechanical and electrical. Those should be fields in your database. I think it would help to read this white paper on database design and re-evaluate how you have your db set up. It will save a lot of heartache down the road.

I would have separate tables for contractors, developers and projects

http://www.deeptraining.com/litwin/d...aseDesign.aspx

[dbalilti]

Great, I need to rethink everything I thought i knew about Databases
Thank you for your help.

But im still confused, what do you mean by seperating tables for contractors, developers and projects? how would that work?
I am looking at the link as well, but if you can give me some feedback it will make understanding databases easier

[dbalilti]

also, this is only the start! I plan on putting electrical/mechanical contracts for Hospitals, two condo types, aparments est. So this database is gonna get complicated.