Auto update combobox

[omegads]

This is what i came up with using all the info gathered.

I've attached the actual database, but i disabled the combo box coding you help me solve because we are currently using it, and the ID numbering was confusing my manager.

i uploaded it to my MEGA cloud because it was to big for the forum upload... sorry

https://mega.nz/#!RgxxXYoB!K99MvYK8GBhWuHf2u48c14yNd0Pm-s5P7v2aqbJ00Ac

Regards

[CJ_London]

regret I am not prepared to download from your site - it requires me to download .exe files and with all due respect I only trust certain locations, https or not.

you should be able to compact then zip the file and load to this site.

Also I need to understand what your question is - this is your software, so you should know what it is doing.

[omegads]

sorry for that, i did not know you couldn't dounload from another site like MEGA.co.nz; well i'll try an explain it,

i have one table that contains al the info of the engineers "ENGINEER_TABLE" and another table that has the working log "LOG TABLE" , the form is made from the to fill all of the information into the log... on that form there is a combo box named Number and a box named Engineer... the first part you already solved it, it grabs the information from the engineer_table, and fills both boxes depending on which you choose first, but when we click save the record, it dumps the information on the form to the record line in the log_table.

that's the part i cannot do. and that's the thing i mentioned before, once i click save, it saves the ID number and not the actual engineer information.

so the question could be like this.

table1 has the info of the engineers (control number and names)
table2 has all the info of the working log including control number and names.
creating a form from table2 and using the coding you provided me to fill the boxes depending on the one you chose,

How can i fill the control and name of the table2 using the fetched control and name from table1 without it returning me the ID number of the record instead...?

finally it could let me attach the file.

[CJ_London]

your log table should not be storing control and engineer values, it should be storing the ID

then in your report modify the recordsource to bring the data from the engineers table.

You will only confuse yourself in time by having fields with the same data called different things e.g. Employee_number/Control. And ID is non specific - rename name as LogID, EngineerID so it is clear which ID it is. Also avoid spaces in field and table names - for fields use the caption property so that labels will appear with spaces. You also have a field called type - this is a reserved word and will also cause issues at some point in the future.

I've modified your db to fix the form and report. I have left your old fields for control and engineer in the log table, but prefixed with zz as a reminder to remove them when you are happy you understand how it now works - they are not used in the report, instead the data from engineers is used.

[CJ_London]

sorry - forgot to change the form combos bound column back to 1

[omegads]

woow thats really amazing, now it's working as it should.... i noticed it was showing the ID instead of the number/employee before i changed back the combos bound back to 1, is that something like vlookup un excel?

but despite of that..

many many thanks... this is just perfect.. with this i know i have a lot to learn but there's always someone that can help...

i think this is a CASE CLOSED hahaha

[CJ_London]

is that something like vlookup un excel?

more like index/match