I am creating a query where when I select the data I am selecting a Change ID number (not primary key but a mix of numbers and letters that can repeat), Date, and Description. What I would like to add is from a sub form called Drawing names a field called drawing name and from another sub form called Revision Notes a field called Revision Notes. (sub form are linked to the Change ID) When I view this query though it only displays the records that have both revision notes and Drawing name fields populated, it will not show records for the Change ID that don't have both of these sub form fields completed. My database will have some entries that will not have data in those fields though that will need to be displayed. How can I do this?

You must be making your subforms from a query. You need to modify the query to have the proper join to show all records in both tables regardless of whether both tables have related records.

I would make the subforms from the tables to prevent this since more than likely if you are entering data in subforms, they are new records in "many" tables. You can always not include the fields you don't want your users to see, if any.

I would also not rely on a repeateable key or ID for the main form since unless you check the data visially on the main form, you may not enter the right data for the right record.

I hope this helps.

mmcdonal