New Records on Multiple Tables with one Form

[JVermast]

Hey Guys,

I have 2 tables (tblSET, tblPROJECT) that have a relationship between them in the form of strPROJID (Project ID)

I need to make a form that has all empty fields in it, and when filled in distributes the entered data to the corresponding field in the corresponding table. I have tried using the design wizard and just putting the fields from all tables onto one form, but the "new record" button is greyed out when I do that. I figure this will include coding of some sort but I am far from a coder.

Thanks ahead of time,

JVermast

 

[godofhell]

When you create the query you need to set the linked relationship to display all records from 1 table and only equal records from the other. Make sure that you are including all the fields from both tables, including the primary key. The problem is your query definition.