product category form Lesson 4 - Microsoft Access Expert 3


	Back to Access Expert 3 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

product category form Lesson 4

John Hall

2 years ago

I use ACCESS 2016. I am trying to recreate the product category form and the product category subform and run into a problem at 10:45. In Format, the Link Masterfield and Link Child Field are blank. When I try to file in the correct information, I get an "overflow" message, and, eventually, "The exppression you entered as an object is closed or does not exist. Then, the computer goes into an unending spin until I close the app. I have verified that the spelling is correct.

	Scott Axton @Reply 2 years ago
In addition to checking spelling in your table ProductT make sure that the field is ProductCategoryID type Number > Long Integer If that isn't the issue take a screen shot of the error message and post it. We may also need to see the design view of your ProductCategoryT and your ProductT. Download the db from the lessons page. Does Richards db work ok?

	John Hall OP @Reply 2 years ago
You correctly identified my error. Thanks for the help.

	Scott Axton @Reply 2 years ago
No problem! If I get an error that is probably my #1 issue. Matching data type.

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

Next Unseen