Help with error 2448: You can't assign value to this object

[zombiezoom]

What is the RecordSource of your 2nd Form?

I am not exactly sure what you mean by RecordSource. However I selected the form that I am trying to input all data and copied and pasted the RecordSource. Hopefully this is what you are looking for. If not, please let me know. Sorry, but I a newbie to ms access and vba. Thanks for your help.

here is the RecordSource:

SELECT runner.runnerid , runner.firstnam e, runner.lastname , runner.streetad dress, runner.city, runner.state, runner.zipcode, runner.email, runner.phone, runner.dateofbi rth, runner.age AS Expr1, runner.gender, runner.shirtsiz e, [event-race-runner].eventid, [event-race-runner].raceid, event.eventname , race.racename, [event-race-runner].runnerid AS [runnerid_event-race-runner] FROM runner INNER JOIN (race INNER JOIN (event INNER JOIN [event-race-runner] ON event.eventid=[event-race-runner].eventid) ON race.raceid=[event-race-runner].raceid) ON runner.runnerid =[event-race-runner].runnerid;

[RuralGuy]

The RecordSource you posted is a query (excellent) that joins the [runner] table with the [race] table and the [event-race-runner] table. It is possible this query is not updateable. Try opening the query by pressing the "..." button on the RecordSource line of the property sheet and see if you can change anything. If it just beeps then the query is not updateable. http://allenbrowne.com/ser-61.html

[patjones]

Hi -

Rural Guy is giving some great insight here.

Are the text boxes that you are assigning the values to bound or unbound? For a little explanation on the difference, see read the first couple of paragraphs of the following page:

http://www.igetit.net/newsletters/Y03_12/BoundUBound.aspx

Pat