[ms office - 2010] Access - Issue with displayed different data in Form than Table

[_kstone]

Hi all,

 

Working on a database that I did have working and now won't!

 

Quick overview: Database has multiple tables for tutor, student, room etc. and these all link to a bookings table, using 1 to many relationships for all. ie. 1 student to many bookings.

 

I have a form that allows the end user to enter bookings by selecting the ID for a student, tutor and room etc.

 

When I select one of the tutors from the drop down list, it says I can't save or edit this record as it's not a valid entry from the tutors table. I know this to not be the case. If i enter the booking in the sub-table in the Tutors table, it accepts it. Then when i look in the form, it displays a different ID number (or sometimes blank).

 

Doesn't anybody know why this might be the case? I have re selected where it looks the data up from, and I can't see any issues. I used the form wizard to create a new form for it, which works, but i wanted to tweak the existing rather than have to re-set up a new one with formatting then update links to it.

 

Unable to share unfortunately due to confidential information stored in it. But can provide more details if needed. Just looking for pointers mainly at what to look for?

 

Thanks!

[NotSoFast]

Been a while since I did this, but I think you need to see which field the drop down is bound to, and also check the query which populates the list of tutors. Get the properties of the field in design view and go from there.

 

Rather than redo the whole form, you could just make this drop down again.

[_kstone]

Thanks for the response. I've removed the drop down and re-added it. Selected the correct Control Source (TutorID) and then did a new query for Row Source (TutorID and TutorName).

 

It gives me a correct list of choices - just not sure why it's not letting me select one?

[NotSoFast]

Same error?

[_kstone]

Yep unfortunately.

 

Managed to replicate the error on another field by putting in a wrong bound column. Tried tweaking this on Tutors field but to no avail. The figure i've put in doesn't seem to match with the MS Access help?

 

Eg. (Working example) - Control Source = StudentID, Row Source = [student Forename] & " " & [student Surname], StudentID

 

The MS Help would indicate Bound Source should be set to 1 as the field should have the StudentID data saved, but show the Forename/Surname expression. However, it's set to 0 and works fine, but doesn't work with 1 set.

 

So, think that might have something to do with it, but i've tried changing this and it hasn't fixed it yet.

[NotSoFast]

I'd probably put the tutor id on there as well just to see what it's being changed to when you choose something in the combo box.