in other words, you are taking the focus of the user off the main form so they can focus on entering the new information ... instead, how about accomplishing the same goal with a tab control?
The main information would be above the tab control so it shows no matter which tab is active
Then fields that are important to fill but not important to see when you are on the other form can be on the first tab.
The second tab can have your subform
"V, C, M, Y are measurements taken"
yes, I understood that from your tablename <smile> ... I was asking what specific measurements they are ... it helps to know a bit about the reason for your database
... what are you measuring? what kind of sample are you working with to take the measurements? how are the measurements being done?
Another consideration is precision.
how many decimal places will the number have? If less than 4, I would recommend storing the data using the currency data type for the accuracy it provides. Single and Double precision numbers are stored in floating point (exponential) format, so they are not accurate enough for what you probably need ... they are susceptable to creating "ghost digits" several places out ... making a number look like it has more precision than it does! so even if you enter 1.2, what is returned to an equation might be 1.200005892
"my old professor would not be happy to see that"
... that thinking probably triggered (and will trigger) other things from the class that would be good to recall now
... so you will end up making him proud <smile>