Unable to enter data in a query

[hpl2001]

(crosspost)

I'm trying to create a query to use as the source for an input form. When I run my query, I can get to the new record line, but I am unable to enter data unless I enter a field for the Box table first. I expect users will want to enter data starting with the ClientId. Can this be done?

SELECT
File.ClientID,
File.DOB,
File.[Last Name],
File.[First Name],
File.[Middle Name 1],
File.[Middle Name 2],
File.[Middle Name 3],
File.Suffix,
File.Alias,
File.[File Comment],
Box.Year,
Box.[Box Number],
Box.Location,
Box.Facility,
Box.[Transfer Number],
Box.[Schedule Number],
Box.[Box Comment],
File.Key

FROM File RIGHT JOIN Box ON (File.Year = Box.Year) AND (File.[Box Number] = Box.[Box Number]);

 

[lameid]

As a rule of thumb, the recordsources for data entry forms should be one table.

In a case where you want to show parent and child records, I would suggest you use a sub form for one of the tables.

But most elementary, you might change the direction of your join from RIGHT to LEFT.