[How do I use a variable with return result from dropdown with MySql lookup?]

Thank you! I said I had to be overlooking something simple. "Forrest for the trees problem." Wrong name in select was exactly the problem. Thanks again!

[How do I use a variable with return result from dropdown with MySql lookup?]

Thank you on the "redundant code from the department of redundancy". Remored it.

As to the problem, it never gets to another form, it should process the insert from this page, but apparently until I can make "Entry_Type" = <select> I can't get past that point.

[How do I use a variable with return result from dropdown with MySql lookup?]

The "Entry_Type" (required in MySql table) is null. I need to populate "Entry_Type" variable with the result from the dropdown </select>.

Modifyed the code since I submitted it, but still haven't hit the correct process / syntax.

[How do I use a variable with return result from dropdown with MySql lookup?]

I have found postings close, but not close enough to find my error.

I am looking up data from a MySql table and putting it in a dropdown box on a form. I can select the item, but apparently not really. I am not able to echo it, or post it to a record.

I'm sure I am missing something simple, but...

Code attached if anyone can show me the errors of my ways.

Thank you.

 

 

[attachment deleted by admin]