Linking Tables

[f5snopro]

I'm currently working on a form which has two tabs...The form opens using a query which asks for an application ID. The information gathered through the query for that ID is displayed on the first page. The second tab has 4 subtabs underneath it. Each have different attributes about the application. If I try to click on a tab, select a textbox, and save, I get the error "You cannot add or change a record because a related record is required in 'Table'".

I just want these tabs to display the values for the specific application queried. How can I accomplish this using my current layout? Thanks.

 

[BSman]

Not sure what the problem is based on your description, but I would suggest eliminating the subtabs. Instead, the first tab should just display the data from the source table for the main form. Then have four more tabs (moved up from the subtabs you mention) to display the related data with appropriate subforms.

You don't say where the control is that you are entering data into. If it's in a subform you may not be saving the applicationID (assuming that is the linking column) in the subforms's source table record.