What I'm trying to do is input data from the user.
The form looks something like the following:
---------------------------------------------------
___________________________________________
ADDRESS: XXXXXXX
SYSTEM: YYYYYYY
________________________________________
DATA:
ZZZZZZZZZZZZZZZZZZZZZZZZ
________________________________________
< < 1 > > >*
____________________________________________
< < 1 > > >*
--------------------------------------------------
The main form simply scrolls through all the ADDRESS and corresponding SYSTEM data. The Subform shows only the DATA input fields to enter data for that specific SYSTEM.
If I have 150 records of different ADDRESS it takes forever to find the right one. I'd like to use a combo box instead however when I change it over to a combo box in the design, it doesn't function properly. I know I'm probably missing a whole bunch of other modifications to get it work right.