Combo box to find a record

[Access_Novice]

In my form called Master Form, the row source is the query called qryParentGymnast to display the values to appear in the pull down menu. I added the fields I want to display on the form. However, instead of adding the field called "Full Name" from the Parents table, I added a Combo Box. In the Combo Box wizard, I selected the option to "Find a record."

In Form View, when I select name from the pull down menu, Access does not jump to the record for the person I selected. In fact, nothing changes on the form. By default this was unbound so no Control Source. Since the values in my menu list come from the "Full Name" field of the Parent table, I set the Control Source to "Full Name." This is still not working.



I get an error message saying "Parent.FullName" field is read-only. I don't want the Combo box in the header (which didn't work anyway).

Since I am selecting a value from a field in the query, I would think this would work. Why is this not working?

Database attached.

[AlexHedley]

I wouldn't bind the control as that would change the current record to the value you choose in the combo.

Here's a Tip that might help

http://www.599cd.com/tips/access/121...?key=AlexForum

[Missinglinq]

This is really part of your other thread here

https://www.accessforums.net/forms/f...ext-40137.html

and the suggestion I gave there, in Post #9, should solve the problem. Basically, you need to do the calculation for FullName in the Query, not in the Table.

Linq ;0)>

[Stubbs]

as a novice found this really helpful, thank you! I was trying to bind the record that I was using as the lookup record. Realised my mistake and problem solved. Cheers.

[Missinglinq]

Always glad when one than one person is helped by a thread!

Welcome to the forum!

Linq ;0)>