Query no longer working in Access 2013

[aytee111]

Sadly I do not have access to Access 2013 and am hoping someone can help me.

My form's record source is a query with a Right Join and it no longer allows him to add records like it does in 2010.

SELECT tblA.*, tblB.DName FROM tblB RIGHT JOIN tblA ON tblB.ID = tblA.D_ID;



Does anyone know what has changed in 2013 that might be causing this to happen?

Thanks

[June7]

Are other edits possible? Why is the RecordSource a join query anyway? Which table is the form supposed to edit and why is the other table included?

[aytee111]

Yes, edits are possible.

I need the name from tblB, hence the join.

Records being added/edited tblA.

[June7]

Can't imagine why 2013 would have issue - never used 2013.

Instead of join, an alternative could be a multi-column combobox that has the name as one of the RowSource fields.

Is there a combobox for selection of ID that is associated with the name?

And as a last resort - DLookup()

[aytee111]

LOL, DLookup is definitely a last resort. I haven't looked at this system in years so was hoping for a quick solution before I delved into doing any modifications, seeing that it works fine on everyone else's computers. Sigh. Thanks for your assistance, anyway.