Well guess what.. I figured out how to make one form, but with data entry.. so i only have one form... however..
In the sub form, when i set Model as "123" it sets StoreItem.Column(1).
However, when i set a new record.. and change the Model.. the old StoreItem.Column(1) changes.. and the value...
Yeh i thought that would be a nice way to do it.. but trying to avoid it.
I was thinking, maybe theres a better way to make only 1 form.. instead of 3.
Right now the forms are;
1. A form that is solely for Data Entry
2. A form that is for modifying single records
3. A form that allows the user...
You can give 2 things a try.
1. Enable AutoCorrect in MS Access
Tools > AutoCorrect Options.. and enable Capitalization.
2. An input mask such as;
Private Sub TextBox_LostFocus()
Me.TextBox = StrConv(Me.TextBox, vbProperCase)
End Sub
Hi guys, my first post on Tek Tips. I got a little problem, i stayed back 2 hours at work trying to figure it out but no luck.
I have a subform, that runs a query on another value in that subform.. and i use this to reference it;
Forms![ServiceJobCardMod]![ServicePartsList].Form![ModelCombo]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.