Ask Your Question
0

Base Form Error

asked 2020-12-12 18:54:01 +0200

KAC352 gravatar image

After I made my table I wanted to create a input form. Using the form wizard I created one. When I start to enter data in the form I get this error, any suggestions?

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-12-12 19:32:39 +0200

Ratslinger gravatar image

Hello,

Images don't always present the needed information. Samples are always better.

Seems there is a problem with you primary key field. Based upon the error, it is (and always should be) a required field. Now it is not shown on your form (noted field is ID). If this field were set as an auto increment field, that would be OK. However it appears it is not set as such.

Either add the field to the form or change the field to an auto increment field.

edit flag offensive delete link more

Comments

Thanks, will try that. Thanks for your help and patients. What kind of sample are you referring too?

KAC352 gravatar imageKAC352 ( 2020-12-12 19:35:40 +0200 )edit

You were correct, changes table ID to auto and error gone. Thanks again.

KAC352 gravatar imageKAC352 ( 2020-12-12 19:39:23 +0200 )edit

@KAC352,

By sample, a copy of what you are using. In this case, a Base file. Whenever posting any document, always be certain it does not include any personal or confidential information.

If, for example your Base file did have such information, copy it, empty the tables of data, and insert data that exhibits the problem. Then post in the question. See -> How do I attach a file to my question/answer?

Ratslinger gravatar imageRatslinger ( 2020-12-12 19:48:36 +0200 )edit

Thanks Ratslinger, you've been extremely helpful. I've got a much better handle on things now. We'll see how it goes once I start playing with queries.

KAC352 gravatar imageKAC352 ( 2020-12-12 21:13:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-12-12 18:54:01 +0200

Seen: 33 times

Last updated: Dec 12 '20