Recordset Not Updateable (Access 2K, Win2K Pro)

It's happening again... I can't recall what I did last time to fix this, either.

My problem is simply this: I want to put a button on a form to display another form where I can enter specific information to a separate table. The column RequestNumber is meant to link Table/Form A to Table/Form B. I can't seem to get this right. How do I make it so, when table/form B is opened, the RequestNumber from table/form B automatically gets written to table/form B if it doesn't already exist? and if it does, just display the info on that record. That is, use automation to create a new record if RecordNumber doesn't already exist or display only the data on table/form B if it does exist. This entails writing RecordNumber from table/form A into table/form B once.

Re: Recordset Not Updateable (Access 2K, Win2K Pro)

Let's say FormA is based on TableA and FormB is based on TableB. I will assume that RequestNumber is a number field; I will note the changes needed if it is a text field later on.
Put a command button cmdOpenB on FormA. The On Click event procedure for the button looks like this: