Help Plz. Creating DropDownBox

[dbalilti]

Basically, Have two Tables with Records. One holds record for mechanical contract information and the other hold electrical contract information.



Many of the projects have both mechanical and eletrical contracts.

I am trying to make a Form that allows me to enter the project number which will spit out the information from both mechanical/electrical contracts (Tables)

I have been able to make a drop down box and enter retreive data, but it is not the data for that project number, it is the data for another project number
(Note all the data for the mec/ele is all correct but for the wrong project number). as well if i press enter, the project number stays the same but all the information changes. Here is a screen shot of what my Form looks like so far.. so you can get a better understanding. Please help!

[June7]

Review: http://datapigtechnologies.com/flash...tomfilter.html

Is this a form/subform arrangement? Are the Master/Child links properties set?

[dbalilti]

Review: http://datapigtechnologies.com/flash...tomfilter.html

Is this a form/subform arrangement? Are the Master/Child links properties set?

All i have is a two tables and I Made a relationship between them in the database tools where I linked all the stuff that is going to always be similar (Like job number and Developer)

thats all I have.

my form just freaked out and doesnt work anymore.. so i guess i need to start from fresh?

Do i need to make some query that links them together? or a new table ? or is the relationship thing enouhg?

Btw... thanks for your help.

[dbalilti]

Another thing.. I Some project numbers have additional records. Like another building under the same project with the same developer and everything but a few changes, like pricing and stuff

[June7]

Your db is only two tables? Review: http://forums.aspfree.com/microsoft-...es-208217.html

[dbalilti]

Your db is only two tables? Review: http://forums.aspfree.com/microsoft-...es-208217.html

Yes, i have two Tables.

One that includes all information for mechanical jobs & one that includes the same Jobs but the mechanical aspects of it.

My fields range from Contract dates to pricing per Square foot. each field is unique to a project number that might share a mechanical aspect to it and even another electrical pricing.

I dont understand why I would need another Table. I made a relationship where i linked the fields that are the same within the electrical/mechanical tables.
I have already made a query that lets me sort my projects by a range of units, and it works flawlessly, showing me both the aspects of the mechanical and electrical Job information.

Lastly. My only issue is that when i change my Job number on my Form, it gives me the infomation of a diffrent job number, and every time i press enter it goes to the next record (I.E goes down the spreadsheet)

I believe that my dropdown box is not doing what its supposed to do. I.E there updating of the dropbox is not doing the proper procedure.

[June7]

You want to provide project for analysis? Follow instructions at bottom of my post.

[dbalilti]

Hope this works. Thankyou again

[June7]

You attached the laccdb file. That is not the db file. It is the temporary locking file that Access creates. Need the accdb file.

[dbalilti]

oops!Mechanical_Electrical Database_May16_Analysis1_Backup.zipMechanical_Electrical Database_May16_Analysis1_Backup.zip

[June7]

There is so much not working with this db. The RecordSource for Condo_Info2 form is just not right. It only pulls JobNumber field and the tables can't be referenced that way. Did you check the query view to see the records returned by that query? Should do 2 subforms, one for each Electrical and Mechanical and the main form RecordSource would be the JobNumber table. Use Master/Child links of the subform container controls to synchronize the related records.

The Condos_Info form has error message about the RecordSource when I try to open.

The two Insert forms won't even open at all.

The Find Developer Project form doesn't find anything.

[dbalilti]

thank you for your help, i will try it out when I have some free time at work!