Inventory Item Filter - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Inventory Item Filter

James Hopkins

3 years ago

Hey Guys, I have created an "Inventory Tracking Form" that I can track the Usage of Products. But I am trying to figure out how to filter view the of the Selected Items in the Continuous Form when the "Chemical Inventory, Fertilizer Inventory, or Product Inventory Button" is Clicked. What is the Best way the Filter the View of the Items of the Button that Selected in the Continuous Form.

	Scott Axton @Reply 3 years ago
Value From a Form

	James Hopkins OP @Reply 3 years ago
Hey Thanks Again Scott, I forgot about that at the time. I got that to work perfectly. But now, I cannot same the get the "Usage Continuous Form" to go to add an NewRec when I enter the Value on the "Subtract, Add, or Reset Inventory Popup Form" I close it and go back to the "Usage Continuous Form".

	James Hopkins OP @Reply 3 years ago
Here's what I got.

	James Hopkins OP @Reply 3 years ago

	Scott Axton @Reply 3 years ago
James first thing I would do is comment out the DoCmd.Close. Make sure that the new form is getting the data you intend. If that is working as intended, add another DoCmd.GoToRecord,,acNewRec right after the "TransactionType=" line Once you move off the current record it should save to the table. Check that out. If all that works, remove the comment from the .Close

	James Hopkins OP @Reply 3 years ago
Hey Scott, I commented out the 'DoCmd.Close' and the Data did not insert the the Form Field. Also, I tried add another 'DoCmd.GoToRecord , , acNewRec' right after the "TransactionType=" line and still no luck.

	Kevin Robertson @Reply 3 years ago
Can you post an screenshot of your form in Design View. Thanks.

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago

	James Hopkins OP @Reply 3 years ago
Guys, I am thinking about creating an "Inventory Transaction Detail Table" for the Subforms. I was wondering if this is the Problem.

	James Hopkins OP @Reply 3 years ago
I also checked the Form Properties, to. To see if I had some wrong selected.

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

Next Unseen

New Feature: Comment Live View