bhunley
04-26-2007, 02:31 PM
I appologize if this is a dumb question, but I am new to VBA in Access. I am trying to alter an existing database. The database uses a main form (F) and a subform (S). Subform S is imbedded in form F. A combo box, called PART NUMBER, is used to change the records shown on subform S through the use of a query. For example, if you select part number 12345, then subform S shows all records for 12345.
At the bottom of the subform it says record x of y. I am trying to pull the y number into a variable so that I can change a textbox based on that value. The values of the textbox would be 0<=y<5 then texbox = Normal, 5<=y<9 then textbox = Skip, and y>=9 then textbox = None.
I know this should be easy, but I am unfamiliar with the process. Is this done through a macro or through a module? Any help would be greatly appreciated. Thank you for your time.
At the bottom of the subform it says record x of y. I am trying to pull the y number into a variable so that I can change a textbox based on that value. The values of the textbox would be 0<=y<5 then texbox = Normal, 5<=y<9 then textbox = Skip, and y>=9 then textbox = None.
I know this should be easy, but I am unfamiliar with the process. Is this done through a macro or through a module? Any help would be greatly appreciated. Thank you for your time.