Combo Box: Help please!

[AccessNewb11]

Hi all,
This forum has been so helpful to this Access Newb, and I've learned alot, thank you!

I am having another problem with my combo box...I made it so that it auto populates information based off of a table and it worked great. I would choose a law enforcement agency, and the information for the agency would auto populate. Then, all of a sudden, it stopped and gave me the error message in the first screen shot when I tried choosing an agency from the drop down list.

The second screen shot shows my AfterUpdate event code. I don't see a problem with it...



Any help would be greatly appreciated!!!

[Bob Fitz]

I believe the error message is telling you that you have two blocks of code for the After Update event of that combo box. The second block of code is the penultimate one in your posted screen shot.

[AccessNewb11]

Ooooh YAY, thank you SO much!

[AccessNewb11]

I have another problem...I tested my form and this error message comes up:

"The Microsoft Access databse engine cannot find a record in the table 'Processor' with key matching field(s) 'ProcessorID'"

It comes up when I choose a name from a drop down list on a combo box I created. Does it have to do with the relationships?

Thanks!

[AccessNewb11]

Hi all,
Thank you for your help in advance!

I have been building a form to help me register people in classes at my work. When I tested the form, I put in the person's name and in the "processor" drop down combo box, I chose a name and tried to save the form. The first screen shot shows the error message that pops up.

I think the problem has something to do with my relationships...? I posted a second screen shot of the relationships as well. The Processor table and the Individual table are connected.

I do not have any code written for the Processor combo box.

The value for the RowSource property on the combo box is as follows:

SELECT [Processor].[ProcessorID], [Processor].[Processor Name] FROM Processor ORDER BY [Processor Name];


Thanks...
~AccessNewb~

MOD EDIT: Merged threads

[Bob Fitz]

What are the following properties of the combo box:
Control Source
Row Source
Column Widths
Bound Column

[AccessNewb11]

Control source is blank...hmm.

RowSource is: SELECT [Processor].[ProcessorID], [Processor].[Processor Name] FROM Processor ORDER BY [Processor Name];

Column Widths: 0";1"

Bound Column: 1

[Bob Fitz]

Try setting the Control Source to ProcessorID

[AccessNewb11]

Wow, that worked, that you SO much Bob!

[Bob Fitz]

Wow, that worked, that you SO much Bob!

Good. Glad to help