Combo Box troubles!

[SuseMarc]

Hi,

Im currently making my first database for a company i work for. As expected im having some troubles hehe im not sure im going about everything the right way. At the moment im trying to create a form which will get product information from one table, display the details in a few combo boxes and based on a selection will store the selections in a separate table. Ive done everything up till that last bit, i cant seem to be able to record the selections in a separate table.

i would appreciate some help as my bosses have to be kept up to speed on my progress and as you can imagine it doesnt look so good when you tell them you havent made any progress hehe.

Cheers

Marc.

 

[KenHigg]

Marc, A combo box has a 'Row Source' and a 'Control Source'. The control source is where the data is stored and is a field from the table that the form is based on. The row source is where the available options in the combo box come from and can be a pre-built query, an sql statement or a list of values.

Hope this helps.

 

[SuseMarc]

it helps me understand how they work more, but when i bind the combo box to [tblJobSheet]![InputMediaSelection1] it still shows me the list in the combo box but it wont let me select anything saying "Control cant be edited; it's bound to the expression 'tblJobSheet!InputMediaSelection1'

Any ideas? :S

 

[Rickster57]

Access projects

If you have not already done so you may find the mdb's that come with MS Access helpful such as the Order Entry and Inventory Projects.

 

[SuseMarc]

lol Cheers rickster im totally cheating now just using northwind as my DB but changing, adding and deleting the relevant things hehe