I cant input data to a form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

I cant input data to a form

Asteropi Papadopoulou

2 years ago

So I'm trying to input a new order in the orderF but as soon as I choose the first product it give me a "Return with GoSub" error, and from there it just goes to hell. It won't let me edit it at all and always starts a new record. I have followed the instruction videos to the T, so I don't know why I can't input any new data in the form. Please help

	Kevin Robertson @Reply 2 years ago
Which video? Lesson Number? Timestamp (if known)? Going to need more details.

	Asteropi Papadopoulou OP @Reply 2 years ago
Beginner Levels 1-2 (all of them) and Invoicing

	Asteropi Papadopoulou OP @Reply 2 years ago
And the error is Return without GoSub, sorry

	Asteropi Papadopoulou OP @Reply 2 years ago
I do have a small difference but I shouldn't think it would matter. Instead of writing the products, I have made a drop down menu to choose the products from. So as soon as I choose a product from the meu, it gives me that error and then it says "The Microsoft data engine cannot find a record in the table OrderT" with key matching fields OrderID

	Kevin Robertson @Reply 2 years ago
Without more details all I can suggest is run down the Troubleshooter

	Kevin Robertson @Reply 2 years ago
Is your Combo Box set up correctly? ProductID ProductName Is it based on a Table or a Query? If a Query are the Joins correct?

	Asteropi Papadopoulou OP @Reply 2 years ago
Didn't work

	Asteropi Papadopoulou OP @Reply 2 years ago
1. If I press to add new order inside a customer I get this debugger msg

	Asteropi Papadopoulou OP @Reply 2 years ago

	Asteropi Papadopoulou OP @Reply 2 years ago
2. If I have the client open and press to open the orderF, I can choose the customer settings but then when I go to the drop down menu I get this "Return without GoSub" error

	Asteropi Papadopoulou OP @Reply 2 years ago

	Asteropi Papadopoulou OP @Reply 2 years ago
If I press OK, it will take the first item and I can even edit the quantity. But it won't let me add another item. Instead it gives me this error that it can't find the orderID record on the table

	Asteropi Papadopoulou OP @Reply 2 years ago

	Asteropi Papadopoulou OP @Reply 2 years ago
then all i can do is close te form but it won't save the record at all

	Asteropi Papadopoulou OP @Reply 2 years ago

	Asteropi Papadopoulou OP @Reply 2 years ago
the product combo box is based on a query and it takes only from 1 table, so no joins

	Asteropi Papadopoulou OP @Reply 2 years ago
The Compact and Repair command didn't work. I'm trying to run the Compile command but it's grey and won't let me press it

	Adam Schwanz @Reply 2 years ago
If compile is grey, that means your already compiled, nothing to compile. It normally turns grey after you run it. What do you mean compact and repair doesn't work? Does it give an error or do anything?

	Asteropi Papadopoulou OP @Reply 2 years ago
It doesn't do anything. I still get the same "Return without GoSub" error

	Asteropi Papadopoulou OP @Reply 2 years ago
I recreated the form and took it step by step. Tha main form works fine, it's the subform that has the problem. As soon as I input the subform and try to run it I get that error

	Kevin Robertson @Reply 2 years ago
Have you set up you Link Master/Child fields correctly?

	Asteropi Papadopoulou OP @Reply 2 years ago
yes I have. It used to work just fine

	Kevin Robertson @Reply 2 years ago
Any Macros or VBA code? Check your tables: make sure the appropriate IDs are present and that they are the correct Data Types. Check your Combo Box: Does it have the correct ID. Has the ID been added to your Query?

	Asteropi Papadopoulou OP @Reply 2 years ago
Fixed it. Thank you

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View