Save and create new record (1 Viewer)

M

Machino

Registered User.
Local time
Today, 07:47
Joined
Mar 26, 2019
Messages
13
Hi mike60smart


The values are now updating properly but the big problem that still remains is that when you open any of the subforms from the tabs they open up with values that a user can accidentally change. I would like them to open to blank fields. Also, to prevent users from adding duplicate vendors, staff, etc, do I change the table values to not allow duplicates? Thanks.
Machino
 
mike60smart

mike60smart

Registered User.
Local time
Today, 12:47
Joined
Aug 6, 2017
Messages
1,913
Hi

You would not allow any of your users to add new Vendors or Staff

They would only be allowed to select from the list available in Combobox's for specific Vendors and Staff.
 
M

Machino

Registered User.
Local time
Today, 07:47
Joined
Mar 26, 2019
Messages
13
Hi mike60smart


I do want users to have the capability to add new staff, customers and vendors. The problem that I am experiencing is that when the form is opened, the user can easily edit the displayed value not knowing that they are affecting a previously saved value. I want them open onto a blank form. They can at any time call up an existing entry edit or delete it if they wish. Thanks
Machino
 
M

Mark_

Longboard on the internet
Local time
Today, 04:47
Joined
Sep 12, 2017
Messages
2,111
Machino said:
Also, to prevent users from adding duplicate vendors, staff, etc, do I change the table values to not allow duplicates?
Click to expand...

For future reference, you CAN prevent duplicates but will often run into issues that make that... problematic.

If Josh Smith is working for you, but you go ahead and hire Josh Smith (No relation) to work in a different department, how would you handle this? If you make it so the first name/last name is unique, do you force one to change their name?

For employees and vendors this does not occur often, but it will for customers. Identifying a different way of making each unique is a better solution.
 
M

Machino

Registered User.
Local time
Today, 07:47
Joined
Mar 26, 2019
Messages
13
Mark
Thanks for your comments. I will keep this in mind as I progress developing this database. At the moment the client is doing it all hand. I am trying to help them move to a more automated way of handling this process.
Machino
 
M

Machino

Registered User.
Local time
Today, 07:47
Joined
Mar 26, 2019
Messages
13
mike60smart


The forms are blanked out which is what I wanted but it also blanks out those records that are already there from showing up in the navigation bar at the bottom of each tab. When I select a tab it shows the navigation bar as 1 of 1. Any way to have both things available? Thanks
Machino
 
You must log in or register to reply here.

Similar threads

raziel3
Prevent Record Cycle or Form Close unless condition is met.
Replies
7
Views
309
Pat Hartman
P
B
Solved Carrying information from form to another and saving the record correctly
Replies
6
Views
296
bonzitre
B
B
Update main form text boxes as subform is filled in? Also, subforms not linking?
Replies
4
Views
408
gemma-the-husky
gemma-the-husky
M
Entwr records with form and subform.
Replies
11
Views
454
moi
M
M
Generic Form with "Save", "Cancel" buttons
2
Replies
38
Views
1,391
jdraw
jdraw

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom