Combo boxes and saving information based off the combo box selection

[RoundTrip]

Alright, So I have ran into a small little issue with my datatbase. I have started making a new form which we will call form 1 and it has a field named WOField which is in another form besides this one that we will call form 2. Now you must first enter the information in table one with all the information and at the end of the form it ask you for the WOField or workorder number field, now when I go to my form 2 it has a combo box where you can select a WOField or workorder number selection based on what is alright in that record. I have that working great! But I want the workorder number or WOField to also save in my table for form 2, it will save all the other information except that, how wiould I go about doing this.

[pbaldy]

It sounds like the combo needs to have its Control Source assigned to that field in the table.

[RoundTrip]

I set the Control Source to the other tables WOField, now it will not let me select anything in the dropdown box :P

[pbaldy]

Is it locked? It's very common for a combo to get its selections from one table but be bound to another. If that's not it, can you attach the db here?

[RoundTrip]

Let me rephrase what
I said I said the table was WOField, but I was just using that as an example it is actually WorkorderNo in this database, it was just easier to type, I took all the control sources off that i had tinkered with

Also the table that it is not working on is Table- JDLink Table and Form- JDLink Table

Hopefully you guys can guide me in the right way to fix it or to correct my mistakes, that would be awesome

*Edited to more up to date db that might make it more simple if you view it

[RoundTrip]

**Scratch that after playing with it, i see that will not work either -_-
Actually, I believe I fixed it, instead of a combo box i used a lookup field instead that got the information from the field WorkOrderNo from the table entry, using a look up data type should not hurt anything should it?

[pbaldy]

I'm not clear where we are now. The combo allows selections as far as I can see. I won't pretend to understand the app though.