Updateable recordset?

[NowwhatdidIdo]

All,

I have a form which is based upon a query made up of three tables. I would like my users to be able to enter new records in one of the tables that makes up the query. I have been successfully able to accomplish this in the past by ensuring that I have the primary keys of all of the tables in question on the form. Those that are populated upon insert are not visibile to the user.

For whatever reason, this does not work in this particular form. I have gone so far as to include every single column in every single table on this form and still nothing.

Any suggestions?

Many thanks,
Jeremy

 

[jdjewell]

Just a thought

Maybe it would work better for you to build your SQL statement on the fly (based upon responses on your form), and then execute the SQL statement (doCmd.RunSQL) based upon an event like a button click.

...again, this is just a thought, but often when I have a form talking to a multitude of tables at once, I find it easy to just break things down into the SQL statements I want to execute, and then handle them appropriately based upon an event.

Cheers!