Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-12-2019, 09:31 AM   #1
zmshaffer
Newly Registered User
 
Join Date: Jul 2019
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
zmshaffer is on a distinguished road
Curious how to use a form to make data entry easier

I am currently creating an Access database that contains:
- a table with vendor information
- a table that has generalized products within
- a table that connects which vendor has which product(s) (many to many)

I am trying to use a form to make entry easier and faster.
I was curious if there was a way to:
- Enter in the vendor and have them stay when doing multiple entries
- Enter in the general product, but having the field return to blank after pressing enter.

zmshaffer is offline   Reply With Quote
Old 07-12-2019, 09:39 AM   #2
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,389
Thanks: 11
Thanked 2,282 Times in 2,234 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Curious how to use a form to make data entry easier

Yes, this can be made simple with a subform. The main form is based on the table on the "one" side of the relationship and the subform is based on the table on the "many" side of the relationship.

Since you have a many to many this means you can add data to the VendorProducts table in two manners:

~Main form based on Vendor table and then a subform based on VendorProducts where Vendor is held constant (in main form) and you select a product in the subform.

~Main form based on Product table and subform based on VendorProducts where Product is held constant (in main form) and you select a Vendor in the subform.

Check this link out for details:

https://support.office.com/en-us/art...a-1e74d6f5f06b
plog is offline   Reply With Quote
Old 07-12-2019, 09:40 AM   #3
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,706
Thanks: 57
Thanked 1,259 Times in 1,240 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Curious how to use a form to make data entry easier

Hi. Welcome to the forum!

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Tags
data entry , data entry forms , form , table relationships

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to make a data-entry form with dynamically updated totals TSGAccounting Forms 1 11-30-2017 03:58 PM
Something Im Making to make it easier to copy different excel sheets to MS acces praizes Modules & VBA 1 11-07-2017 11:37 AM
[Just Curious] Easier way to check for open forms? ersocia Modules & VBA 20 09-06-2012 06:13 PM
try to make form for data entry -=seth=- Forms 3 04-12-2007 08:05 AM
Making data entry easier.... egg Forms 4 09-01-2006 08:43 AM




All times are GMT -8. The time now is 04:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World