Form Help!!

[Optimus_1]

Hello



I have attached a DB with a basic form on and was wondering if anyone could let me know how exactly i select dropdown boxes for the 'Team' and 'LeadManager' options and select them from the Tables already defined.

Also should this form i have created populate the tblMain?.

Thanks

[jzwp11]

On your form, remove the textbox controls for the lead manager and the team and replace them with 2 combo box controls. The combo box wizard should help you tie the combo box to the appropriate tables that hold the info you want. Make sure to bind each combo box to the underlying field in tblMain (the combo box wizard will prompt you for this as well)

[Optimus_1]

Hi,

Thanks for assistance, I have changed the boxes and the seem to be working in some way!.

What am i doing wrong when trying to populate the tblMain from this form?.

If you could advise what i am doing wrong id be grateful

Many thanks

[jzwp11]

You had the form bound to a query that all of the table, it should only be bound to tblMain. I've made the modification in the attached DB.