Form Help - combo add record to table

Hi all,

Ive got a form called frmAddMachine, which adds a new machine to a table called tblMachine. tblMachine has the following fields: MachineID, Make, Model, SerialNumber, YearManufacture, RegNumber. I have also got 2 other tables: 1 called tblMake and 1 called tblModel. On frmAddMachine ive got 2 combo boxes which ive set to lookup values from tblMake and tblModel to i can select the make and model in the combo boxes. Im trying to get it so i can select the make and model from the combos and then fill in the other text boxes below like SerialNumber, YearManufacture, RegNumber. I can do all that now on the form although the make i select in the combo and the model i select in the other combo do not apear in the table tblMachine. All the other data like SerialNumber etc appears in the table but the make and model fields are left blank.

Please help with this, What do i need to do in order to get this working?

Thanks
Jim

on your form are you using a query back or just stright into the tables

Thanks for the speedy reply mate - very appriciated.

The form tblMachine goes straight back into the table, theres no query. Would i need one to do what i need? and how would it be structered?

Thanks

on your form were you have a combo box, have a look at the control sources property make sure the this shows the right item in your table (the one you say the combo box will not pass the data to your table).

Let me know once you have checked this i will help further

the control source property is blank on both combos. I take it this will effect it?

Yes, that is your problem you need to put the field name were you want the data to go to, this should then work.

Let me know if that sorts it.

Yep that sorted it m8, thanks alot for the help

Not a problem, if you need any more help just ask, if you want you can add me to your message thing and i will help were possible or tell you were to get help