Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Access won't let me add a record after a search is done

JasinC19 (Programmer) (OP)
4 Jan 05 9:49
Hi everyone. Let me briefly explain. My form has a search box that sets the recordsource of the form to a stored procedure. After this, clicking the add new record button works as normal, but I can't type anything into the fields. When I reset the recordsource to select * from ... it works fine.

I suppose that for some reason, it wont allow you to add a record when the recordsource is narrowed down. Is this the case? If so, I guess I will have to manually reset the recorsource to select * when they click the add new record button.

The problem is, I can't find a suitable event for that.

Can anyone help me out? Thanks.

KenReay (Programmer)
4 Jan 05 10:30

Not absolutely sure about this, but... I think the result set from a stored procedure is read only in Access, hence no updates and/or add new


Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

JasinC19 (Programmer) (OP)
4 Jan 05 10:45
I think you're right. So is there an event I can use for when the user clicks the built in add record button?
KenReay (Programmer)
4 Jan 05 14:50

How about replacing the built in button with a custom button, and then use its on click event to trigger an SQL INSERT command (possibly a stored procedure)


Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

JasinC19 (Programmer) (OP)
4 Jan 05 16:10
Yeah, thats what I ended up doing, although I really didnt want to. I like the built in controls and the people that will be using this program are used to them, but oh well. Life goes on.

Thanks for everyone's suggestions


Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close