Simple question about combo box

[djmurphy58]

I'm a beginner Access user who is having some troubles with using a combo box. Here's the deal:

I have a table of cost codes. Each cost code has a series of attributes. I have created a form with a field for cost code. I want this field to be a combo box so that I can simply select the cost code from my tblCostCodes. When I do this though, the cost code I select gets add to my tblCostCodes. Say for example I select cost code "1510.01" from my tblCostCodes. The combo box will select it, but it will also add a new cost code "1510.01" to my table.....so now I have duplicate cost codes. Why does it do this?

Thanks

 

[KenReay]

Hi

Is the form which contains the combo box is bound to the table of costcentres ?

Is there any code in teh after update event of the form

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[djmurphy58]

Ken
Probably a stupid question, but: how do I tell if the form which contains the combo box is bound to the table of Cost Codes?

No, there is no code in the "After Update" event.

Thanks

 

[KenReay]

Hi

You look at the recordsource property of the form (in design view)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK