This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 4%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
I have 6 field Buy, Closed, Selling, Cover, Stoplevel, and Hitstop. Hit stop is a checkbox.'
If I make an entry in Buy and another in Stoplevel and check Hitstop I want the entry in Stoplevel to be copied to Closed
A family of Microsoft relational database management systems designed for ease of use.
Unfortunately I can't. This is probably not a typical database. I don't really understand them and i don't need to i just want this one to work for me. It's the only one I will ever build, and it may seem like duplication but stoplevel may or may not be used but closed is always used and if stoplevel is used it may or may not equal closed. Stoplevel will only equal closed when hit stop is checked. I'm not sure how to go about doing what you suggest I've tried:
If HitStop = yes Then StopLevel = Closed and
If Me.HitStop.Value = yes Then Me.StopLevel.Value = Me.Closed.Value and
If Me.HitStop = True Then StopLevel = Closed and either get error messages or things don't work right
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
In the After Update event code (VBA) of HitStop you can try add this
If Me.StopLevel Then
Me.StopLevel = Me.Closed
End If
It doesn't sound like you are going to follow George's advice. Having the same value in StopLevel and Closed seems unnecessary.
You can use the after update event VBA of the Hitstop to check the values of StopLevel and Buy and if they are not null, set the StopLevel value to the value of the Closed field.
Actually, this would not be a good idea to do in the first place.
There are formal rules of Database Normalization which describe how tables and the relationships between those tables should be designed.
I strongly recommend you put further work on this aside and invest time in learning those Database Normalization rules so you can correct the design flaw here.
Because we don't really have any context for this particular table, and can only assume from the terms used that it has something to do with Stock investments, it would be premature to suggest a revision of the table at this point. That said, we can identify and address the specific flaw.
One of the fundamental principles of good relational table design is that each data point is stored once, in one field, in one table. Therefore, copying a value from a field called "Stoplevel" to a field called "Closed" is an invalid design. In order to help you correct it one would need to know more about the intent underlying the database.
Search the internet for discussions of "Database Normalization".
Here's one for starters. https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/access/database-normalization-description
I also like the series of YouTube videos from this channel. Although they are as not technically complex as they could be, they do explain enough about the concepts involved to help beginners get started.
https://youtu.be/GFQaEYEc8_8?si=to9NUSJgKYrIwsmm
Your assumption is right is is tracking currency. The thing is I'm already doing this just manually. If there is an entry in stoploss and the hits top check box is marked i enter the same number in closed. Im just trying to automate the process. The hits top is just a reference not used for anything