will not allow input of data - Easy Search Form in Microsoft Access, Part 2


	Back to Easy Search Form 2 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

will not allow input of data

Nathan Shepard

2 years ago

I set up a form with 5 fields. PassID,Description,class,EmailAddress,UsernameorEmailAddress, I used a query with the fields listed. The And query was put on the same line across the screen. The Or search was staggered in a step pattern.

I setup a screen with the fields and the And Search Btn and a Or button.

	Sami Shamma @Reply 2 years ago
Nathan you need to be more precise with your description of the problem. Also include some images. Go to the query and see if you can add a record to it. (updatable)

	Nathan Shepard OP @Reply 2 years ago

	Nathan Shepard OP @Reply 2 years ago
So the issue is that the form will not allow input of not even one character. Any Suggestions and comments are welcome. I am flabbergasted by the fact that I can not get to even take one character. I followed Richards video and did it exactly as he did it. Thank you for help. Nathan

	Richard Rost @Reply 2 years ago
Is this an unbound form?

	Kevin Robertson @Reply 2 years ago
As Sami said, check your Query. Not Updateable

	Nathan Shepard OP @Reply 2 years ago
I added a record . Record 232. It won't copy here. prior to entering data to the query. It gave me a Enter parameter error. with a flashing cursor wanting data to be entered. Got this for one field. Then it went to a data sheet with 55 records.

	Richard Rost @Reply 2 years ago
Sounds like something's not spelled right. Enter Parameter Value

	Nathan Shepard OP @Reply 2 years ago
The or search from the query will accept one record. It does give me a parameter error. Then a blank single record.

	Nathan Shepard OP @Reply 2 years ago
Yes, Richard all fields are unbound. That was the easy part.

	Kevin Robertson @Reply 2 years ago
Please post a screenshot of your Query in Design View (make sure you crop the image and make it large enough for us to see it clearly).

	Nathan Shepard OP @Reply 2 years ago
I watched the parameter Value video. I am checking spelling.

	Nathan Shepard OP @Reply 2 years ago
Spelling seems to be ok. Still will not take input on even one character. I pressed the "And Search Btn" and the (Or Search btn) It opened a data sheet with records. I have 233 records. It showed 55 records. Don't know what criteria its using for the query. Still checking spelling.

	Nathan Shepard OP @Reply 2 years ago

	Nathan Shepard OP @Reply 2 years ago
I don't know how to shrink the screen. the best I can do.

	Richard Rost @Reply 2 years ago
Is your form locked? Allow edits YES? Fields locked?

	Nathan Shepard OP @Reply 2 years ago

	Nathan Shepard OP @Reply 2 years ago
Edits is set to yes. Record locks set to no locks. I looked at other properties. Nothing applies.

	Nathan Shepard OP @Reply 2 years ago
I seem to have a problem with trusted folders. No error showed up. Could this be a problem?

	Nathan Shepard OP @Reply 2 years ago
I tried a new way from Richards videos. 14 hoursAUTOSearch Form 2.0. It worked. I can search on multiple fields. It works for an And search. That video has no OR search. Thank for the input Sami, Richards and Kevin. Without you input. My brain would of stayed in neutral. You got me thinking. Nathan (Jeff)

	Nathan Shepard OP @Reply 2 years ago
this post is now closed!!!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Easy Search Form 2.

Next Unseen

New Feature: Comment Live View