Record makes undesired automatic change

johansena

Registered User.
Local time
Today, 09:25
Joined
Jun 15, 2013
Messages
12
Hello,

I have a training database that I have set up and utilize to track attendee data and who is registered to which course.

I have a course registration table that has a course title field which is a drop down list populated by course titles from the courses table, and a trainee id field.

For whatever reason, when I view reports or queries that draw from this table, access will make changes to the first record in the course registration table course title field i.e. it will take whoever is in the first record, and change the course they were registered to.

Any insights in to what might be causing this would be greatly appreciated.
 
If I had to guess, you use a combo bound to that table to run the report. That combo should not be bound (have a control source).
 
Some things I had read on other sites had led me to think that might be an issue as well. My database is pretty mature now, can I change that without corrupting other forms/queries/etc.
 
Ok just checked the properties for that field, and Bound Column is 1. Is this the issue?
 
No, it should not have a control source if you're using it to select records to print or view. If you look at it in design view, it should say "Unbound".
 
Row Source: SELECT [Courses].[Course_ID], [Courses].[CourseTitle] FROM Courses ORDER BY [CourseTitle];

Can I add a control source property here? or where?
 
That's fine. Right above that in the property window is Control Source. Is there anything there?
 
Ok, so I was looking at the properties for my Course Registration table. I see the control source property when I look at the form I use to enter or modify registrations. The control source is set to CourseTitle. The CourseRegistration table uses CourseID as the data source for the Course Title field. Is this where the error may be coming from? Row source for my Course Registration form is as follows:
SELECT Courses.Course_ID, Courses.[CourseTitle]
Bound column is 1

Thanks for the help on this, it is driving us all nuts!
 
As I've said, it shouldn't have anything in the control source if you want to use it as a "find record" or "select record to print" combo. However, on the form where you enter or modify records, it would need to have a control source. Sounds like you're trying to use the same combo for both, which you can't.
 
Would binding the combo box to the second column instead of the first help any?
 
No, you'd still be changing the underlying record, just changing which value was saved there.
 

Users who are viewing this thread

Back
Top Bottom