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 3 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 HallOP
@Reply 3 years ago
You correctly identified my error. Thanks for the help.
Scott Axton
@Reply 3 years ago
No problem! If I get an error that is probably my #1 issue. Matching data type.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 3.
