Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subform - unable to add new records

Status
Not open for further replies.

flash1

MIS
Feb 19, 2002
11
CA
The Front end of my database is in Access 2000. The back end was upsized to SQL Server 2000. I am experiencing problems with various subforms where it is no longer possible to add new records in the subform.

The record source of the subform is based on a query that pulls records from two tables using an inner join query statement. The subform does display existing records and it is possible to modify the these records using the subform.

The subform and the main form are related through the child - master property.

Why can I no longer add records using the subform?

Flash1
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top