Make data input into form from comboboxes, text boxes etc write to table

[whitelockben]

Hi all,

I have a form made now and a table created which I want the form to write to. Is there a way I can make the form write data to this specific table and specific field?

E.g. I have put cascading comboboxes in and I want the info selected from these, from other table to be entered into my new table?

Any ideas,

Thank you in advance!!

 

[vbaInet]

This is what bound forms are for. You can read up on that.

Happy reading!

 

[whitelockben]

The form itself is bound, however i designed the form, with cascading comboboxes etc which are unbound and there is only one field in the form which is bound to the table I want my data input into.

My comboboxes and text boxes have some vb associated which gets data from another table, however I want the data it gets placing in my new table.

Can I make this work?

 

[vbaInet]

Like I mentioned in my last post, you should be using a form and not a table.

 

[whitelockben]

I made a total mess of my reply. I had edited, can you please re-read and respond.

Thank you very much for your time!

 

[vbaInet]

I made a total mess of my reply. I had edited, can you please re-read and respond.

Ok.

Yes, if you bind the combo box (via the Control Source) it will work. Just ensure that the Bound Column is the ID field.

 

[whitelockben]

Thank you!!

 

[vbaInet]

No problemo!